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.

N8755EGokoffski Anthony · Larkspur, CAS/N 28-7690200 N8756EHowell Richard · Louisville, KYS/N 28-7690201 N875CFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020102 N875GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881069 N875SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881744 N8761FCook William M · Warsaw, INS/N 28-7790265 N8764CMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7690160 N8764EFa40 Plane LLC · New Port Richey, FLBuilt 1976 · S/N 28-7690202 N8765CLatitude Aviation LLC · Spring, TXBuilt 1976 · S/N 28-7690161 N8765EMoore Alex W · Deep Gap, NCBuilt 1976 · S/N 28-7690203 N8765FSmith Nelson · Brighton, IAS/N 28-7790266 N876SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881745 N8771CSummit Aviation LLC · Spokane, WABuilt 1976 · S/N 28-7690163 N8773CScott Ansell E · San Diego, CAS/N 28-7690164 N877GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881469 N877HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 2844132 N877MDMd Max LLC · Dover, DEBuilt 2023 · S/N 2881662 N8787CBrolan Aviation LLC · Kansas City, MOBuilt 1976 · S/N 28-7690165 N8788ECoastal Fliers Inc · El Cajon, CABuilt 1976 · S/N 28-7690204 N878WSWallace State Community College · Hanceville, ALBuilt 2021 · S/N 28020033 N8797EVan Beckum Peter · Farmington, CTBuilt 1976 · S/N 28-7690209 N87MCNorthern Blue Skies Inc · Shawano, WIBuilt 1980 · S/N 28-8090104 N87WAltitude Aviation LLC · Lenoir, NCBuilt 1999 · S/N 2843296 N880PUPurdue University Trustees · West Lafayette, INBuilt 2025 · S/N 2881949 N8814FBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7790268 N881KBAero Quest LLC · Olive Branch, MSBuilt 2023 · S/N 28020115 N881PUTrustees Of Purdue University · West Lafayette, INBuilt 2025 · S/N 2881965 N8824CRodriguez Carlos S · Poughkeepsie, NYBuilt 1976 · S/N 28-7690167 N8842SMcdowell Karen · Dunedin, FLS/N 2837032 N885ACWingsleasing LLC · Wichita, KSBuilt 2020 · S/N 2881396 N886ACAir Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881397 N886ECUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816262 N887KJCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2021 · S/N 28020025 N8889EWestern New York Flying Club Inc · Bowmansville, NYBuilt 1976 · S/N 28-7690214 N888BMDeverapalli Vishnu Reddy · Duluth, GABuilt 1977 · S/N 28-7890282 N888CCStevens Terry L · New Plymouth, OHBuilt 1979 · S/N 28-7916324 N888EJInternational Air Services Inc Trustee · Carson City, NVS/N 2816082 N888GMStevens Ryan · Presque Isle, MEBuilt 1977 · S/N 28-7716264 N888QCShipley Ryan Paul · Keller, TXBuilt 1977 · S/N 28-7716175 N8890FSchoenherr Aviation LLC · Washington, MIS/N 28-7790271 N8899ERgp Aviation LLC · Wilmington, DES/N 28-7690215 N889TWUniversal Aviators Academy Inc · El Monte, CABuilt 1989 · S/N 2837023 N8903CSummit Aviation LLC · Spokane, WABuilt 1976 · S/N 28-7690170 N890GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881070 N890SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881800 N890UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020196 N892ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881398 N892DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020041 N893ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881412 N8946CPilawski Darren J · Spring Hill, FLBuilt 1976 · S/N 28-7690171

Back to AD 2016-07-21