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.

N24139Averett University · Danville, VABuilt 2011 · S/N 2843697 N241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011 N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051 N241ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881610 N2421WJohnston John · Sheboygan, WIBuilt 2023 · S/N 2881631 N2425MTap Solutions Inc · San Diego, CABuilt 1977 · S/N 28-7816283 N2427M18 Rwy LLC · Falmouth, MEBuilt 1977 · S/N 28-7816284 N2427UGalante Anthony R · Saint Clair, MIBuilt 1979 · S/N 28-8090044 N2429TKlassen William Peter · Davis, CABuilt 1976 · S/N 28-7690390 N242AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881732 N242NDHaye Patrick W · Minot, NDBuilt 1999 · S/N 2842052 N242NPBa Flight Experience LLC · Margate, FLBuilt 1976 · S/N 28-7790137 N2433MHarkey Aviation LLC · Sherrills Ford, NCBuilt 1977 · S/N 28-7816285 N2434MSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1977 · S/N 28-7890251 N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253 N2436MVenture Aviation Inc · Arlington, MABuilt 1977 · S/N 28R-7837089 N2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedBuilt 1985 · S/N 28-8516056 N243AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881733 N243DWSijtsma Wouter · Ladson, SCS/N 2844088 N243GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881113 N243JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020019 N243MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881708 N244AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881734 N244JALee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYBuilt 2021 · S/N 28020024 N244MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881709 N244NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842054 N2450UDouble D Flyboys LLC · Taylorsville, UTBuilt 1979 · S/N 28-8090046 N2458QM&M Aviation LLC · South Windsor, CTS/N 28-7716102 N245AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881758 N245CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881355 N245DWJr Aircraft LLC · Dayton, OHBuilt 2003 · S/N 2844090 N245TCTexas State Technical College · Waco, TXBuilt 2024 · S/N 28020188 N245TPStrable Sam · Cecil, OHBuilt 1999 · S/N 2843301 N2460QHamilton Aviation Group LLC · Lula, GABuilt 1977 · S/N 28-7790398 N2460UAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 28-8090048 N2461QJessi Air Ltd · West Salem, OHBuilt 1977 · S/N 28-7790399 N2464QWilson Jeff · White Bluff, TNBuilt 1977 · S/N 28R-7737035 N246CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881002 N246NDGlobal Aviation Corp · Farmingdale, NYBuilt 1999 · S/N 2842056 N2471USchroeder Nyla R · Minneapolis, MNBuilt 1979 · S/N 28-8090049 N2473WCahill Chad · Edmond, OKBuilt 1985 · S/N 28-8590073 N2473YFunderburg Erskine R · Pell City, ALBuilt 1985 · S/N 28-8590074 N2476MPremier Flight Center LLC · Hartford, CTBuilt 1977 · S/N 28-7816286 N2477SAverett University · Danville, VABuilt 2012 · S/N 2843700 N2478VKozura Ronald J · Pine Grove, PABuilt 1985 · S/N 28-8516057 N247MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881710 N2480VLyons Emily A · Homewood, ALBuilt 1985 · S/N 28-8590075 N2485XLostetter Evan · Bakersfield, CABuilt 1985 · S/N 28-8516069 N2488MMeads Rodney L · Camden, NCBuilt 1977 · S/N 28-7816289 N2488PPs Engineering Inc · Lenoir City, TNBuilt 1999 · S/N 2843282

Back to AD 2016-07-21