Registered aircraft · 10,537

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:2004-25-16-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1') 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:2004-25-16-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
  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:2004-25-16-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
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.

N3653AKlemenhagen David · Wasilla, AKBuilt 1969 · S/N TC-1309 N36565Maxwell James B · Lewiston, IDBuilt 1968 · S/N TC-1142 N365FDci Air LLC · Dodge City, KSBuilt 1980 · S/N 421C0854 N365HStavair LLC · Gulf Breeze, FLBuilt 1965 · S/N TC-843 N365RESouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A0459 N3664GMarshmont Aviation LLC · Greenville, SCS/N TJ-280 N36673Gta Air Inc · Addison, TXBuilt 1980 · S/N TH-1143 N36696Ovajet Group Inc · Miami, FLBuilt 1978 · S/N 34-7870353 N366DHummer Family Capital Aviation LLC · Boonton, NJBuilt 1966 · S/N 310K0230 N366MN366m LLC · Dover, DES/N 414A0026 N366MCHastings Steve T · Corpus Christi, TXS/N 414A1005 N3670EFresh-Pic Harvest Inc · La Quinta, CABuilt 1980 · S/N TK-124 N3670UHoffman Kevin · Chatsworth, GABuilt 1980 · S/N TC-2332 N36724Reeves Richard G · La Verne, CABuilt 1980 · S/N TC-2333 N3673RArtie Aircraft LLC · Trenton, MOBuilt 1980 · S/N TH-1150 N3673UCastor Care LLC · Mount Pleasant, SCBuilt 1980 · S/N TH-1149 N3674GSudduth Ronald C · Lineville, ALBuilt 1980 · S/N TH-1151 N3677UNinomiya James T · Placitas, NMBuilt 1980 · S/N TC-2337 N36795Rudy Neal W · Peoria, ILBuilt 1978 · S/N 34-7870371 N367ATL&R Aircrafts Corp · Boynton Beach, FLBuilt 1972 · S/N 310Q0522 N367PBuzzard Air Service LLC · Carleton, MIS/N 23-367 N3681GRed Wolf Aviation LLC · Wilmington, DEBuilt 1980 · S/N TH-1157 N36827Thaviation LLC · Louisville, KYBuilt 1978 · S/N 34-7870374 N3682ZIliamna Air Taxi Inc · Iliamna, AKBuilt 1980 · S/N TH-1159 N3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1980 · S/N TJ-298 N36885Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 340A0681 N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835 N368JEJones Enterprises · Nacogdoches, TXBuilt 1980 · S/N TH-1145 N3690DR B M Corporation · Cropwell, ALBuilt 1980 · S/N TJ-306 N3692XLake Elmo Aero LLC · Lake Elmo, MNBuilt 1981 · S/N ME-369 N3694LRegistered aircraftBuilt 1980 · S/N TH-1176 N3695LBg Aviation LLC · Waukesha, WIFirst renewal noticeBuilt 1980 · S/N TC-2353 N3695NWalton Jerry Prince Jr · Monticello, FLBuilt 1980 · S/N TH-1192 N36961Alpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0494 N3696LP51d Mustang LLC · Bigfork, MTBuilt 1980 · S/N TJ-310 N369ACAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 34-7870095 N369KJGrace Aire Inc · Corpus Christi, TXBuilt 1978 · S/N 31-7852108 N369KMHoon David DBA · Wolf Creek, MTBuilt 1972 · S/N TC-1501 N369RKKrum Force 1 LLC · Wichita, KSBuilt 1976 · S/N 421C0072 N369RMRothschild Jonathan Trustee · Tucson, AZBuilt 1976 · S/N 421C0071 N36AVCook Greg R · Willis, TXBuilt 1992 · S/N TH-1657 N36CGDay Edwin Daniel · Richland, WABuilt 1969 · S/N 310P0075 N36CLCl415 Aviation Salvage LLC · Belgrade, MTFirst renewal noticeS/N 1068 N36CTExecutive Mission LLC · Round Rock, TXBuilt 1990 · S/N TH-1579 N36DGRegistered aircraftBuilt 1977 · S/N 340A0331 N36DLCroll Robert H III · Jacksonville, ORBuilt 1969 · S/N 310P0113 N36EB42 North Systems Aviation LLC · Hingham, MABuilt 1984 · S/N TJ-465 N36EWSalzer Dustin J · Weatherford, TXS/N 310Q0521 N36GAGrand Aviation LLC · Wilmington, DES/N 348433049 N36KHermiston Aviation Inc · Hermiston, ORS/N TC-1299

Back to AD 2004-25-16 R1