Skip to content

Registered aircraft · 601

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-16') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-16')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-16')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-16')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-16')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N100CBC3 Air LLC · Wilmington, NCBuilt 2009 · S/N 525B0327 N100JWBluebird Air LLC · Prospect, KYBuilt 2006 · S/N 525B0086 N102CPSecoda Aviation 2 LLC · Muncy, PABuilt 2023 · S/N 525B0712 N103DSHr Leasing LLC · Dover, DEBuilt 2005 · S/N 525B0031 N103KKRf Aviation LLC · Midland, TXBuilt 2018 · S/N 525B0568 N106JTMountain Air Charter LLC · Dallas, TXBuilt 2006 · S/N 525B0106 N107PTPapa Tango LLC · Petaluma, CABuilt 2006 · S/N 525B0127 N108ELucky Stars LLC · Missoula, MTBuilt 2015 · S/N 525B0476 N108LAPrice Services Inc · Monticello, ARBuilt 2007 · S/N 525B0176 N109TWLegacy Jets LLC · Wilmington, DEBuilt 2010 · S/N 525B0338 N10TRNtr Aviation LLC · Dallas, TXBuilt 2011 · S/N 525B0354 N110RFGyansys Equipment LLC · Carmel, INBuilt 2022 · S/N 525B0682 N115SMJet Aircraft 5 LLC · Wilmington, DEBuilt 2007 · S/N 525B0201 N116AACorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N 525B-0194 N117BEvp Systems Aviation LLC · Santa Barbara, CABuilt 2018 · S/N 525B0561 N1181PCi2 Holdings LLC · Carrollton, TXBuilt 2023 · S/N 525B0687 N11SGOk3 Air Leasing LLC · Heber City, UTBuilt 2019 · S/N 525B0599 N11THLipsey Leasing LLC · Newark, DEBuilt 2006 · S/N 525B0056 N11VHRegistered aircraftBuilt 2025 · S/N 525B0745 N121DMMaisley Aviation LLC · Jasper, ORS/N 525B0500 N121TSSky King Charters LLC · Cincinnati, OHBuilt 2023 · S/N 525B0692 N122ERAdvisors Aviation LLC · Saint Louis, MOBuilt 2005 · S/N 525B0030 N122PAPafford Medical Billing Services Inc · Hope, ARBuilt 2010 · S/N 525B0346 N123CJElevation Air LLC · Miami, FLBuilt 2007 · S/N 525B0149 N123CZOkay Inc Trustee · Wilmington, DEBuilt 2009 · S/N 525B0313 N124BLLofton Robert A · Brawley, CABuilt 2007 · S/N 525B0181 N125CDAero Dynamic Medical LLC · Pleasant Grove, UTBuilt 2023 · S/N 525B0710 N125DGFugal Aviation LLC · Pleasant Grove, UTBuilt 2006 · S/N 525B0060 N125PLSutherland Lumber & Home Center Inc · Jenks, OKBuilt 2008 · S/N 525B0290 N129DGDutra Group · San Rafael, CABuilt 2008 · S/N 525B0269 N129TTTaun-Taun Transportation LLC · Healdsburg, CABuilt 2022 · S/N 525B0684 N12GSBlue Sky Inc · Wilmington, DEBuilt 2006 · S/N 525B0122 N131MJEagle Aero Inc · Lafayette, LABuilt 2006 · S/N 525B0097 N137BGCroell Aviation LLC · New Hampton, IABuilt 2005 · S/N 525B0032 N139CJAir Queso LLC · Harrison, OHBuilt 2007 · S/N 525B0139 N13DCMarketing Strategy LLC · Missoula, MTBuilt 2022 · S/N 525B0677 N13ECTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525B0919 N144ALB&K Leasing Company Inc · Big Bear Lake, CABuilt 2005 · S/N 525B0044 N145CGPatrick & Brigitte Alias LLC · Fort Lauderdale, FLBuilt 2015 · S/N 525B-0480 N1482PBurcham Rentals Inc · Holts Summit, MOBuilt 2019 · S/N 525B0578 N149WWCorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N 525B0175 N151GMHei Aviation LLC · Powell, OHBuilt 2014 · S/N 525B0452 N157TWHf Air LLC · Fresno, CABuilt 2007 · S/N 525B0157 N159JSB&L Adventures LLC · Sealy, TXBuilt 2005 · S/N 525B0038 N15ZZShamrock Air LLC · Arnold, MOBuilt 2008 · S/N 525B0221 N160BRDft LLC · Central Point, ORBuilt 2014 · S/N 525B0454 N162ECCitation Dreams LLC · Inlet Beach, FLBuilt 2005 · S/N 525B0026 N174AACorsair Two LLC · Hillsboro, ORBuilt 2007 · S/N 525B0196 N174SJSierra Juliet LLC · Greeley, COBuilt 2007 · S/N 525B0174 N175AACorsair Two LLC · Hillsboro, ORBuilt 2006 · S/N 525B0068

Back to AD 2007-23-16