Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N5907ERiver City Flying Club Inc · Valley Center, KSBuilt 1978 · S/N 17271957 N5907YMueller Carri Ann M · Palmer, AKBuilt 1966 · S/N 18-8414 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

Back to AD 79-10-03 R2