Skip to content

Registered aircraft · 5,443

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:2016-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21') 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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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:2016-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
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.

N43954Georgetown Aircraft Rental Inc · Granger, TXBuilt 1977 · S/N 28-7890032 N43956Freeflight Aviation LLC · Allentown, NJBuilt 1977 · S/N 28-7890033 N43957Ocbc Ventures Aviation LLC · Los Angeles, CABuilt 1977 · S/N 28-7890034 N43959Explore Gourmet LLC · Wyandanch, NYBuilt 1977 · S/N 28-7890035 N43966Sims Kenneth Leon · Desert Hot Springs, CAS/N 28R-7737139 N43967Jo Air Inc · La Mesa, CABuilt 1977 · S/N 28R-7737140 N43983Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28-7890038 N43984New England Flyers LLC · Franklin, MAS/N 28-7890039 N43DFParagon Flight Training Co · Fort Myers, FLBuilt 2024 · S/N 28020200 N43LCRoy Mark A · Sanger, TXBuilt 1976 · S/N 28-7790203 N43PFCollum Aviation LLC · Milton, FLBuilt 1979 · S/N 28-7916362 N44006Martin Seth J · Kingman, INBuilt 1977 · S/N 28-7816021 N4400ACae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881107 N4400DCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881108 N4400FCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881139 N4400PCae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2013 · S/N 2843711 N4400SCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843712 N4400WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843713 N4401ECae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881141 N4401NCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881203 N4401PCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881204 N4401UCae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2019 · S/N 2881239 N4401WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881240 N4402ACae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881241 N4402TCae Aviation Academy Phoneix LLC · Mesa, AZBuilt 2013 · S/N 2843717 N4402UCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843718 N4403LCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843721 N4403WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843725 N4403ZCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843726 N4407XRegistered aircraftS/N 28-7690010 N4409XKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1975 · S/N 28-7690011 N440AAFms Bank · Fort Morgan, COBuilt 2019 · S/N 2881254 N440AJRocky Mountain College · Billings, MTBuilt 2019 · S/N 2881094 N440FTAviation Express Inc · Greenville, WIBuilt 1982 · S/N 28-8216219 N440NDPars Avn Corp · Wilmington, DEBuilt 2006 · S/N 2842271 N440TCTexas State Technical College · Waco, TXBuilt 2024 · S/N 28020191 N440UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020162 N4411XVandelay Aviation LLC · San Diego, CABuilt 1975 · S/N 28-7690013 N4414XMellett Aircraft Inc · Ambler, PABuilt 1975 · S/N 28-7690005 N44191C H Aviation Services Inc · Wilmington, DEFirst renewal noticeBuilt 1976 · S/N 28-7690330 N4421XN4421x LLC · Sarasota, FLBuilt 1975 · S/N 28-7690007 N442CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881131 N442LCKnudtson Kirk · Kasson, MNBuilt 1978 · S/N 28-7890455 N442PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843498 N4437SVenture West LLC · Mesa, AZBuilt 2015 · S/N 2844156 N4437WVenture West LLC · Mesa, AZBuilt 2015 · S/N 2844157 N4438DMa Aviation LLC · Danville, ILBuilt 2015 · S/N 2844158 N443PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843499 N44426Skyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842396 N4443QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842397

Back to AD 2016-07-21