Skip to content

Registered aircraft · 5,458

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.

N156LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842198 N157ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010053 N157LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842199 N157TASpace Coast Aircraft Co · Meritt Island, FLBuilt 1998 · S/N 2842029 N157WAUnited States Air Force - Owner · Hanscom Afb, MABuilt 2019 · S/N 2881157 N158CCRegistration Pending · Visalia, CARegistration pendingBuilt 1977 · S/N 28R-7737081 N158NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842030 N158PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841150 N1597BRehman Furqan · Germantown, MDBuilt 1997 · S/N 2843104 N159ERTetterton Marshall O · Crescent City, FLBuilt 1989 · S/N 2841211 N159LHFarmingdale State University · Farmingdale, NYS/N 2842200 N159NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842031 N1601SRussell Bryan E · Joshua, TXS/N 28-7790057 N160THolmberg Michael G · Hinckley, OHBuilt 1978 · S/N 28-7816373 N161AWAir Ward Inc · Columbia, CABuilt 1979 · S/N 28-8016078 N161BGWilson James R · Midlothian, VABuilt 1978 · S/N 287816527 N161DERegistered aircraftBuilt 1977 · S/N 28-7816295 N161KMParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7716136 N161MBKerf 25 Corp · Wilmington, DEBuilt 1982 · S/N 28-8216163 N161PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841156 N161SMMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 28-7916508 N161TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881549 N1627HCirrus Services Inc · Fargo, NDBuilt 1977 · S/N 28-7716028 N1628HWarrior N1628h LLC · Huntsville, ALBuilt 1977 · S/N 28-7716029 N162AVPiper Aircraft Inc · Vero Beach, FLS/N 28010078 N162LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842361 N1632HM & B Aero LLC · York, PABuilt 1977 · S/N 28-7790319 N1637HGross Leslie W · Perry, MES/N 28-7716030 N1638HKaczmarek James J Jr · Parksley, VABuilt 1977 · S/N 28-7716032 N163AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010061 N163LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842362 N1640HArcher 1640h LLC · Oscoda, MIS/N 28-7790321 N1646H3k Aviation LLC · Iron Station, NCS/N 28-7716033 N1648HWcc Eco LLC · Arvada, COS/N 28-7790322 N164AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010060 N164DPAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 28-8016190 N164ERSilver Express Co DBA · Miami, FLBuilt 1989 · S/N 2841180 N164GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881457 N164LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010063 N164SWNew England Aviation LLC · Plainville, CTBuilt 1975 · S/N 28-7690077 N165AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010059 N165FTParis Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216195 N165JYSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1977 · S/N 28-7890225 N165LHRochester Air Center LLC · Canandaigua, NYBuilt 2011 · S/N 2844144 N165PPiper Aircraft Inc · Vero Beach, FLS/N 28020290 N1660HAtd Pilot Training LLC · Kansas City, MOS/N 28-7716037 N1661HRed Tail Scholarship Foundation · Tuskegee, ALS/N 28-7790325 N1663HSecure Uicc Corp · Glen Burnie, MDS/N 28R-7737007 N1668Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020178 N166LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881373

Back to AD 2016-07-21