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.

N901APEvanson Scot A · Monroe, TNFirst renewal noticeS/N 27-7405416 N901EGK Mcdaniel LLC · Mesa, AZBuilt 1977 · S/N 34-7770426 N901KASpiegel Richard J · Sun City, AZBuilt 1973 · S/N 34-7450045 N901TKAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 31T-7904028 N901VWAviation Business Corp · Saint Louis, MOS/N 27-2101 N9021V9021 LLC · Sheridan, WYS/N TH-233 N9023QRegistered aircraftBuilt 1970 · S/N TH-68 N9024SBorders Nowell W · Edinburg, TXBuilt 1965 · S/N TC-963 N90253Wood Roger Weaver · Sale Creek, TNBuilt 1972 · S/N 27-4779 N9025QVee Tails Of Flying Cloud Inc · Excelsior, MNBuilt 1970 · S/N TC-1356 N9029VNeighbor David H · Fairway, KSBuilt 1972 · S/N TC-1485 N902BAEcho Charlie LLC · Manvel, NDBuilt 1979 · S/N 414A-0324 N902DRBaron Dreams LLC · Inlet Beach, FLS/N TH-1825 N902MTAircraft Trustee Services Inc Trustee · Dover, DES/N 27-8054038 N90346Mittelsted John J · Dickinson, TXBuilt 1967 · S/N 27-3604 N9035SRick Aviation Inc · Newport News, VABuilt 1965 · S/N TC-956 N9038SRed Rock Flyers LLC · Flagstaff, AZBuilt 1965 · S/N TC-961 N903JDAirventure LLC · Fort Lauderdale, FLS/N 421C0420 N903KKHanger Nine Point Five LLC · Aztec, NMBuilt 1970 · S/N 33701263 N9044VThomas Richard D · Orange City, FLBuilt 1972 · S/N TH-216 N904BCFox 3 Partners LLC · Virginia Beach, VABuilt 1981 · S/N 421C1027 N904SCMedical Disposables Corp · Orlando, FLBuilt 1981 · S/N 31-8152194 N904TMax Q Aviation LLC · Cocoa Beach, FLBuilt 1974 · S/N TC-1755 N9053KBrown Aero Technologies LLC · Alexander City, ALBuilt 1977 · S/N 34-7870035 N9054SWhiskey Lima Aviation LLC · Duluth, GABuilt 1978 · S/N TC-2160 N9057QCurrier Justin B · Rixeyville, VABuilt 1971 · S/N TC-1366 N9058QHeffley Lynn · Pottsboro, TXBuilt 1970 · S/N TH-95 N9058STeam Training Institute LLC · Atlanta, GABuilt 1978 · S/N TC-2161 N905AAGraber Joel C · Collins, MSS/N TK65 N905KKRdc Air LLC · Lithia, FLBuilt 1970 · S/N 33701348 N905TJWhittington Peter M · Jupiter, FLS/N 31-7952204 N906MBWdm Seneca LLC · Augusta, GABuilt 2013 · S/N 3449472 N906QKVilla Aircraft Maintenance Inc · Fort Lauderdale, FLBuilt 1977 · S/N 34-7770309 N90725Aghchay Derek N · Los Angeles, CAS/N 310L-0151 N907LJAgl Aero LLC · Mckinney, TXBuilt 1969 · S/N 30-1862 N9083SRobinson Charley C · Guthrie, OKBuilt 1978 · S/N TJ-152 N908CKNew Tex Capital LLC · Plains, TXBuilt 1978 · S/N 340A0445 N908KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 34-7970060 N9094QAhrens Nathan · Groveland, CABuilt 1970 · S/N TH-107 N9098QBuckeye Baron LLC · Sunbury, OHBuilt 1970 · S/N TH-109 N909CMFlightpath LLC · Montgomery, NYS/N TH-2022 N909DCTwin Piston Aviation LLC · Salisbury, NCBuilt 1980 · S/N 340A0998 N909PHInternational Air Services Inc Trustee · Carson City, NVS/N 23-1800 N909RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 34-7770069 N909RFPastjo Aviation LLC · Charleston, WVBuilt 1982 · S/N 414A0840 N909TBCrawford Greg · Humnoke, ARBuilt 1971 · S/N TC-1387 N90APDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 31P-7300148 N90DMDel Martin Lp · Spring, TXBuilt 1972 · S/N 340-0048 N90EBJet Set Aircraft Inc · Van Nuys, CABuilt 1976 · S/N TH-793 N90EFBardoo Sean L · Massapequa, NYBuilt 1976 · S/N 27-7654081

Back to AD 2004-25-16 R1