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.

N43408Miloud Chadd K · Fort Worth, TXBuilt 1984 · S/N 28-8416048 N4342CTwin City Air Activities Inc · Rock Falls, ILBuilt 1984 · S/N 28-8416051 N4344PAbele Benjamin · Lexington, NCBuilt 1984 · S/N 28-8490051 N43455Siskiyou Aero LLC · Ashland, ORBuilt 1984 · S/N 28-8416055 N4345BHamilton Justin M · Knightsen, CABuilt 1984 · S/N 28-8416057 N4345CAeroservice Aft Corp · Miami, FLS/N 28-8416059 N4345GG & M Aircraft Inc · Wheat Ridge, COBuilt 1984 · S/N 28-8416061 N4346DLane Community College · Eugene, ORBuilt 1984 · S/N 28-8416111 N4347DAviation Flight Services Inc · Cumming, GABuilt 1984 · S/N 28-8416081 N4347GPurdue Pilots Inc · West Lafayette, INBuilt 1984 · S/N 28-8416062 N4347HKillian Regina · Prosper, TXBuilt 1984 · S/N 28-8416063 N4347KRegistration Pending · Augusta, KSRegistration pendingBuilt 1984 · S/N 28-8416064 N4348FRegistered aircraftBuilt 1976 · S/N 28-7790018 N4349FStriegel Jory D · Washington, DCS/N 28-7790019 N4349LParker Air LLC · Mobile, ALBuilt 1984 · S/N 28-8416068 N4349YSpence Willard J · Davin, WVBuilt 1984 · S/N 28-8416071 N434SPittsburg Flyers LLC · Pittsburg, KSBuilt 1981 · S/N 28-8290085 N4352DAshdown Adrian · Canandaigua, NYBuilt 1984 · S/N 28-8416073 N4352GBouza Mario · Santa Clara, CABuilt 1984 · S/N 28-8416074 N4353LSummit Flight Academy LLC · Peculiar, MOBuilt 1984 · S/N 28-8490062 N4356BVu Ai T · Aiea, HIS/N 28-8490089 N4358TGriffith Aviation Inc · Griffith, INBuilt 1984 · S/N 28-8416040 N4359CSmith Kevin Lee · Peachtree City, GAS/N 28-8416088 N4359YSportsman Airpark Inc · Newberg, ORBuilt 1984 · S/N 28-8490073 N435NDPars Avn Corp · Wilmington, DEFirst renewal noticeBuilt 2006 · S/N 2842270 N4360FNorth County Flight Training Inc · Carlsbad, CABuilt 1976 · S/N 28-7790022 N4363DRaf Aircraft Pilot Services LLC · Wilmington, DEBuilt 1984 · S/N 28-8416098 N4364TComputec Technical Solutions Inc · Eighty Four, PABuilt 1984 · S/N 28-8416102 N43652Tarcelo Maria Jocelyn F · Sun City, CABuilt 1984 · S/N 28-8416107 N43654Aeroventures Flying Club Inc · Lawrenceville, GABuilt 1984 · S/N 28-8490086 N43655N43655 LLC · Newark, DEBuilt 1984 · S/N 28-8490087 N4365DGriffin Donald A · Alma, ILBuilt 1984 · S/N 28-8416105 N4365FBumgardner Jerry C · La Crosse, WIBuilt 1984 · S/N 28-8490082 N4367GDimenno Phillip A · Windermere, FLBuilt 1984 · S/N 28-8490090 N4368HMuskogee Airmen Inc · Muskogee, OKFirst renewal noticeBuilt 1984 · S/N 28-8416110 N4368UBorges Jr Frank · Angwin, CABuilt 1984 · S/N 28-8490094 N4368VWaunch Robert L Trustee · Eastsound, WABuilt 1984 · S/N 28-8490095 N4369NJ J Bagley Transportation Co LLC · Chalfont, PABuilt 1984 · S/N 28-8490096 N436GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881177 N436NDFly By Knight Inc · Hammond, LABuilt 2004 · S/N 2842213 N43700Aviation Career Enrichment Inc · Atlanta, GABuilt 1984 · S/N 28-8416117 N4370KHodges Berry Farm LLC · Willacoochee, GABuilt 1984 · S/N 28-8416116 N4370NThunderbird Aviation · Bloomington, MNBuilt 1984 · S/N 28-8490098 N4371DKakurata Shinya · Portland, ORFirst renewal noticeBuilt 1984 · S/N 28-8490100 N4372SBelser Mark · Avon, OHBuilt 1984 · S/N 28-8416115 N43742Hesston College · Hesston, KSBuilt 1984 · S/N 28-8490108 N43745Coyle Andrew J · Pierre, SDS/N 28-7816020 N4374NPalmet Luis A Alonso · Homestead, FLS/N 28-8416128 N4374UN4374u LLC · Dover, DEBuilt 1984 · S/N 28-8416129 N43751Casey Brian · Hawley, PABuilt 1977 · S/N 28-7890008

Back to AD 2016-07-21