Constellation Leasing LLC
Rochester New York United States
Extend to Max 31 Aug 16. PAN - Expected audit date 07-May-2018. Authorization granted for audit #6 to be conducted remotely iaw IS-BAO Policy 2020-01 ref. Covid-19 with a potential 2-year Stage 2 registration. Also auhtorized Amanda Ferraro to conduct a consecutive audit at this operator due to Covid. On June 15, 2020 granted a two-month registration extension, until 31 August 2020, due to the impacts of the Covid-19 outbreak in the operator.  Yvonne authorized Marta maiden to do the Stage 3 SMS evaluation on audit #7 in order to assess her readiness for the S credential.  PAN - Expected audit date - 14-Mar-2023.
02-16-2023
651
 
 
Registration
JUN-30-2026 3
08-31-2020
06-30-2026
Yes    
Yes    
Yes  
  No
  No
   
8
0
8
36
2
No N/A
No
United States
Org Structure Records
Unable to display report. You do not have sufficient permission.
03-16-2023 Ava Shubat / Marta Maiden 05-05-2023
Audit History
James Holtby/James Hobart
JUN-30-2011
10-18-2011
06-30-2013
JUL-17-2013
Larry Schriver/Rod Kottmann
09-09-2013
St 2-2yr
06-30-2015
06-04-2015
Flashman/Marinus
06-26-2015
St 2P-1yr
06-30-2016
06-07-2016
Bernie Flashman
06-15-2016
St 2-2yr
06-30-2018
05-09-2018
Amanda Ferraro
07-06-2018
St 2-2yr
06-30-2020
07-07-2020
Amanda Ferraro
08-27-2020
St 3-3yr
06-30-2023
03-16-2023
Ava Shubat / Marta Maiden
05-05-2023
St 3-3yr
06-30-2026
AMS Audit Records
Unable to display report. You do not have sufficient permission.
Reg application forms
 
Website
Application
ID
Operator Name for Certificate
Contact Person Name
Contact Person Company
Contact Person Email
Shipping Address
Operator City for Certificate
Operator State for Certificate
Operator Country for Certificate
Contact Person Phone
Member Association
Auditor Name
Auditor Company
Auditor Email
Auditor Phone
Logo
Include in
Website
Listing
Payment Type
Created At
Updated At
Transaction ID
Stripe Transaction ID
Additional
Copies
Additional
Copies
Count
SMS Stage
Displayed
Registration Type
Fleet Size Category
Shipping City
Shipping State
Shipping Country
Shipping ZIP
Amount
Include
logo on
certificate
Website
Certificate
ID
Subscription?
Additional Certified
Copy Order
Program
QBID
Programme
Category
QBID
Subcategory
QBID
Payment Method
Payment Date
Net Amount
Comment
Asked
Invoice
Invoice Sent
Date
Will Send
Check
Check Received
Date
Payment Export ID
Payment Method Aux
Payment Date Aux
Original
Certificate
Reissue
Quantity
Refunded
Refund Type
Refunded
Amount
Refund Fee
Refund - Total
Cost to IBAC
Final
Received
Amount
Refund - Reason
Refund Date
Status
Transaction Type Aux
Refund - Stripe Transaction ID
Soft
Delete
Soft Deleted By
Soft Deleted At
Soft Deleted Reason
Payment
Cancelled
Payment Cancelled By
Payment Cancelled At
Payment Cancelled Reason
Related
Operator
Operator - Organization
Related Master Organization
table for single login
Master Organization table for single
login - OrganizationName
Persons table for single
login - Full Name
Shipment Option
FedEx Account
Shipping
Fee
Amount
DHL Account
Authorization
for publishing
Stage
Audited Organization Name
Audit End Date
Related
Audit
Operator Category
Billing City
Billing State
Billing Country
Billing ZIP
Billing Address
 
605 Brian Humes Brian Humes Two Piers Interactive brian@twopiers.com 1229 Harriet Ave Saint Joseph Michigan United States 2692083382   Brian Humes Two Piers Interactive         Invoice 05-17-2023 01:53 PM 05-17-2023 01:53 PM q93x3sAcVhXf   Yes 1       Saint Joseph Michigan United States 49085 60     Yes   1 IS-BAO 14 13       Plus 1 certified copies Yes       BAO-RAF-801       1         0 60     Soft Deleted Payment   Yes JoelleElHajj 05-19-2023 10:59 AM Test         453 Constellation Leasing LLC 651     Pay Shipping Fee   50         453   Saint Joseph Michigan United States 49085 1229 Harriet Ave
914 Constellation Leasing, LLC Paul Sheldon Constellation Leasing, LLC paul.sheldon@cbrands.com 1299 Scottsville Rd, Hangar 6 Rochester New York USA 585.430.9068   Ava Shubat Aviation Safety Solutions       Yes cc 05-05-2023 10:04 PM 05-05-2023 10:05 PM Ib1ueyqXkh ch_3N4WkhKpCaNC07Ib1ueyqXkh     Yes 3-year Registration 2-10 Aircraft Rochester New York United States 14624 2700         1 IS-BAO 4 10 Credit Card / Stripe 05-05-2023             BAO-RAF-792       1         0 2700     Paid Payment                   453 Constellation Leasing LLC 651     FedEx Account 318479526 0 318479526 Yes     2163 Private          
177 Constellation Leasing, LLC Bryan Heise Constellation Brands bryan.heise@cbrands.com 1299 Scottsville Road Rochester New York United States 1 (585) 615-0470   Amanda Ferraro Aviation Safety Solutions     https://tools.ibac.org/storage/logos/6v3bnJDmUVwqY6QhXlVmgSRu0HNndIw123pJ8cQC.jpeg   Invoice 09-08-2020 06:39 PM 09-08-2020 06:39 PM 7KImDumKQtVC   Yes 7   Renewal - 3-year Registration Multi-Aircraft Operators Rochester New York United States 14624 2245 Yes       1   4 10 Credit Card / Stripe 09-10-2020 $2,179.59   Yes 09-08-2020     BAO-RAF-38 Credit Card / Stripe 09-10-2020   1         0 2179.59     Paid Payment                   453 Constellation Leasing LLC                     565            
TOT 1696                                             8               5005   0     3   22 33     $2,179.59                   3     $0.00 $0.00 0 4939.59                                         50                      
Paul Sheldon Jonathan Zaffer
Paul.sheldon@cbrands.com jonathan.zaffer@cbrands.com
+1 585 430 9068 +1 585 749 3591
12818 2744
Portal Access
Unable to display report. You do not have sufficient permission.
1299,Scottsville Road
14624
 
Unable to display report. You do not have sufficient permission.
Progressive subscription payments
Unable to display report. You do not have sufficient permission.
824 days 4545 days 17 days
01-05-2022
 
Delete
To delete this record, please first enter the reason for deletion and then click on the button below.
Organization-453
N
Y
N
Multi Aircraft
North America
NBAA
 
 
BAO453
Created on March 23, 2015 at  2:48 PM (EDT). Last updated by Devraignes, Daniel on July 12, 2023 at  1:06 PM (EDT). Owned by Program, IS-BAO.
IS-BAO Program
Daniel Devraignes
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.

We're glad you're interested in doing more with Quickbase!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quickbase with others in your company.

Your work email
Your company