Registered aircraft · 40,473

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

N59086Maxwell James B · Lewiston, IDBuilt 1973 · S/N 611-74 N5908DClark Stephen N · Walnut Cove, NCBuilt 1956 · S/N 22-4570 N5908UEcostudio Real Estate LLC · South Amboy, NJBuilt 1970 · S/N 28-26505 N5908WPrindle Ry · Hillsboro, ORBuilt 1965 · S/N 28-2879 N5909EOwens Flight Training LLC · Lafayette, LABuilt 1978 · S/N 17271958 N5909WCornebise Ricky · Levelland, TXBuilt 1966 · S/N 28-3032 N590DCDonald Pohland J · Anchorage, AKBuilt 1958 · S/N 18-6245 N590FLDonnelly Matthew J · Romulus, NYS/N 28-7125452 N590RUSA Jet And Helicopter Inc · Denver, NCBuilt 1965 · S/N 28-21327 N590SProspect Ridge Aviaton Inc · Morganton, NCBuilt 1981 · S/N 172RG0818 N5910DEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4572 N5910WMetz Tyler B · Bridgeport, WVBuilt 1966 · S/N 28-3040 N5911LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496102 N5911QFuller Christopher · Ottsville, PABuilt 1965 · S/N 3164 N5911UMoore Air Inc · Honolulu, HIBuilt 1970 · S/N 28-26824 N5911WBrimmer Harold C · Longview, TXBuilt 1966 · S/N 28-3042 N5912DRenner David L · Ferndale, CAFirst renewal noticeBuilt 1956 · S/N 22-4574 N5913DCaldwell Caleb Z · Anchorage, AKBuilt 1956 · S/N 22-4575 N5913XHay Johnny L · Bethel, OHS/N 49 N5914UShawver Aviation LLC · Knoxville, IAS/N 28-26794 N5914VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1977 · S/N 28-7716214 N5914WSteadfast Avatiion LLC · Mesa, AZBuilt 1966 · S/N 28-3124 N5914XTamvakis Dimitri · Orlando, FLS/N 50 N5915DMason Jack A · Reidsville, NCBuilt 1956 · S/N 22-4577 N5915QHaslem Patrick S · Dimondale, MIBuilt 1965 · S/N 3166 N5915UOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1970 · S/N 28-26897 N5915WTheobald Daryl · Aberdeen, SDBuilt 1966 · S/N 28-3139 N5916JUnited States Air Force - Owner · Eglin Afb, FLBuilt 1980 · S/N 17273845 N5916UForsman Airways LLC · Glenwood, MNBuilt 1970 · S/N 28-26780 N5917VHeyano Norman J · Dillingham, AKBuilt 1977 · S/N 28-7790512 N5917WHiggins James L · Harrisville, MIBuilt 1966 · S/N 28-3187 N5918JStansfield Carl B · Springdale, UTS/N A1500218 N5918WLathrop Patrick W · Kent, WABuilt 1966 · S/N 28-3189 N5919QBig Sky Adventures LLC · Nicholasville, KYS/N 3168 N5919UDewater Mark · Mulberry, ARBuilt 1970 · S/N 28-26561 N591RVSims David L · Mc Alpin, FLBuilt 2025 · S/N 93270 N5920DBates Matthew T · Springfield, VABuilt 1956 · S/N 22-4582 N5920WSynergy Aviation LLC · Greer, SCBuilt 1966 · S/N 28-3223 N5921HHoehne Michael G · Vienna, VABuilt 1949 · S/N 16-542 N5921WStearns Edwin Ben Jr · Eloy, AZS/N 28-3227 N5922EAerial Scouting Solutions LLC · Sioux Center, IABuilt 1978 · S/N 17271963 N5922FNeel Aviation LLC · Lakeland, FLBuilt 1976 · S/N 28-7715158 N5922PWiseman Transport LLC · Henderson, TXBuilt 1959 · S/N 24-1009 N5922UPagan Jose A · Kokomo, INBuilt 1970 · S/N 28-26408 N5923WPremier Pilots LLC · Herriman, UTBuilt 1966 · S/N 28-3246 N5924FN5924f LLC · Cocoa, FLS/N 28-7715159 N5924UOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1970 · S/N 28-26815 N5924WPribbenow Dennis A · Payson, AZBuilt 1966 · S/N 28-3273 N5926DToste Greg · Newcastle, CABuilt 1956 · S/N 22-4589 N5926FRegistered aircraftBuilt 1976 · S/N 28-7790143

Back to AD 80-04-03 R2