Skip to content

Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N734DQHartz Farm Management Inc · Stuttgart, ARBuilt 1977 · S/N 17268777 N734DRDrnek Scott D · Hayward, CABuilt 1977 · S/N 17268778 N734DSFly Aviation Corp · Wilmington, DES/N 172-68779 N734DTSilver Express Co DBA · Miami, FLBuilt 1977 · S/N 17268780 N734DVWilliams Gary R · Albuquerque, NMBuilt 1977 · S/N 17268782 N734DYFour Delta Yankee Inc · Pennington, NJBuilt 1977 · S/N 17268785 N734DZBlotsky Jim Darin · Fargo, NDBuilt 1977 · S/N 17268786 N734EATschacher Farms Inc · Manville, WYBuilt 1977 · S/N 17268787 N734EDScapegoat Aviation LLC · Choteau, MTBuilt 1977 · S/N 17268789 N734EJLavery Sam · Morgantown, WVBuilt 1978 · S/N U20604828 N734EQAero-Sphere Inc · Longmont, COS/N 17268800 N734ERGrantham Jack Q Jr · Stockbridge, GAS/N 17268801 N734ESDc Aero LLC · Ramona, CAS/N 17268802 N734EWRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WAS/N 17268806 N734EYRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1977 · S/N 17268808 N734EZMiklos Bruce A · Meridian, IDBuilt 1977 · S/N 17268809 N734FALima-001 LLC · Muscatine, IABuilt 1977 · S/N 17268810 N734FDJays Aircraft Maintenance Inc · Costa Mesa, CABuilt 1977 · S/N 17268813 N734FECenturion Aviation Services LLC · Racine, WIS/N 17268814 N734FJRobert Peccia And Associates Inc · Helena, MTBuilt 1977 · S/N 17268818 N734FMD2 Government Solutions LLC · New Bern, NCBuilt 1977 · S/N 17268820 N734FNSafety In Motion Flight Center Inc · Puyallup, WABuilt 1977 · S/N 17268827 N734FQBraithwait Leonard D · Washougal, WABuilt 1977 · S/N 17268823 N734FRWhite Jack A Jr · Naples, FLBuilt 1977 · S/N 17268824 N734FSDouble Bridges Aviation LLC · Enterprise, ALBuilt 1977 · S/N 17268825 N734FZArdent Air LLC · Byhalia, MSBuilt 1977 · S/N 17268831 N734GAN734ga LLC · Wilmington, DEBuilt 1977 · S/N 17268832 N734GEGoebel Marvin A · Colorado Springs, COBuilt 1977 · S/N 17268836 N734GFSchroeder Clarence H · Big Lake, AKBuilt 1977 · S/N 17268837 N734GRN734gr LLC · Grand Prairie, TXS/N 17268847 N734GSLeverock Richard C · Port Saint Lucie, FLBuilt 1977 · S/N 17268848 N734GUMidwest Consulting & Management LLC · Oneill, NEBuilt 1977 · S/N 17268850 N734GWRwr Air Inc · Tok, AKBuilt 1978 · S/N U20604832 N734GXSundance Aviation Inc · Richland, WABuilt 1977 · S/N 17268853 N734GYFisher Global LLC · Conway, ARBuilt 1977 · S/N 17268854 N734HBCalkins David M · Anchorage, AKBuilt 1973 · S/N 18502260 N734HCChandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 17268858 N734HDState University Of New York · Farmingdale, NYBuilt 1977 · S/N 17268859 N734HJMb Airworks LLC · Saint Petersburg, FLBuilt 1977 · S/N 17268864 N734HMWhite Carlos W · Rathdrum, IDS/N 17268867 N734HVKeaney Patrick A · Auburn, MABuilt 1977 · S/N 17268874 N734HW206 LLC · Portland, ORBuilt 1980 · S/N P21000602 N734HXWaters Aero- Marine Inc DBA · South Thomaston, MES/N U20604837 N734HZAster Labs Inc · Shoreview, MNBuilt 1977 · S/N 17268878 N734JAAerodyme Corp · South Burlington, VTBuilt 1977 · S/N 17268879 N734JBYoung John A · Honea Path, SCBuilt 1977 · S/N 17268880 N734JCRegistered aircraftBuilt 1977 · S/N 21062107 N734JDBergman James H · Buckley, WABuilt 1977 · S/N 17268882 N734JKKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268888 N734JNLyon Logan W · Yukon, OKBuilt 1977 · S/N 17268891

Back to AD 87-20-03 R2