Skip to content

Registered aircraft · 17,027

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

N6462SRoss Mitchell B · Ledyard, CTBuilt 1967 · S/N 15067262 N6465FBurris Donald E · Lawton, OKS/N 15063065 N6466FGee Ryan S · Luverne, MNBuilt 1966 · S/N 15063066 N6467SFenton Harry L · Rhome, TXBuilt 1967 · S/N 15067267 N6468SMorse Timothy W · Erie, COBuilt 1967 · S/N 15067268 N6469GMaxwell Daniel · Albuquerque, NMBuilt 1970 · S/N 15071969 N6469SWeber Worldwide LLC · Cedar Rapids, IABuilt 1967 · S/N 15067269 N6470FMatuska James H · Deary, IDBuilt 1966 · S/N 15063070 N6473SUlman Gary T Trustee · Mountain Iron, MNBuilt 1967 · S/N 15067273 N6474FDodd Michelle J · Riverton, KSBuilt 1966 · S/N 15063074 N6476FKnowles Brian Thomas · Windsor, NCBuilt 1966 · S/N 15063076 N6477SJuhl Aviation LLC · Luverne, MNS/N 15067277 N6479GGibbons Asher · Mobile, ALBuilt 1970 · S/N 15071979 N647MTArbo Elijah B · Mount Chase, MEBuilt 1970 · S/N 17259158 N6480FHaithcock Stephen · Oxnard, CABuilt 1966 · S/N 15063080 N6480GLloyd Trent E · Central Valley, UTBuilt 1970 · S/N 15071980 N6480SKline James R · Kokomo, INBuilt 1967 · S/N 15067280 N6481FWood James N · Samson, ALBuilt 1966 · S/N 15063081 N6483FRegistration Pending · Seattle, WARegistration pendingS/N 15063083 N6483GPeterson Cassandra L · Poplar Grove, ILBuilt 1970 · S/N 15071983 N6483SBlue Skies Aviation Of Wi Inc · Pulaski, WIBuilt 1967 · S/N 15067283 N6484FGrant Clinton A · Portage Des Sioux, MOS/N 15063084 N6486GRomeo Aviation Inc · Cumberland, WIBuilt 1970 · S/N 15071986 N6487GRedell Donald J · Lake Geneva, WIBuilt 1970 · S/N 15071987 N6487SSouth Louisiana Community College · Lafayette, LABuilt 1967 · S/N 15067287 N6488FLee Michael R · Kelso, WABuilt 1966 · S/N 15063088 N6488GKrog Steven L · Hartford, WIBuilt 1970 · S/N 15071988 N648DWDewhipet LLC · Sibley, LABuilt 1966 · S/N P206-0252 N648FRegistered aircraftS/N 18255185 N6492FSkywagon Aero LLC · Wilmington, DES/N 15063092 N6496GJbm Aviation LLC · Mc Leansboro, ILS/N 15071996 N6497GLynch David C · Columbus, INBuilt 1970 · S/N 15071997 N6499GSkadberg Christen G · Knife River, MNBuilt 1970 · S/N 15071999 N64BBBlazey Brian I · Palmyra, NYBuilt 1967 · S/N 15066150 N64CVValle Richard · Wellington, FLBuilt 1963 · S/N 205-0508 N64RBBurnett Ramon R · Alpine, CABuilt 1968 · S/N 18258811 N64RKKoril Richard A · Overgaard, AZBuilt 1964 · S/N 18255686 N6500FMoore Howard W · Camden, TNBuilt 1966 · S/N 15063100 N6500SSpitfire USA Ltd · Rockville, MDBuilt 1967 · S/N 15067300 N6501FHoward James S · Arlington, TXS/N 15063101 N65025Killian Larry D · Hampton, ARS/N R172-0123 N6502SPetrosyan Joseph · Rancho Cordova, CABuilt 1967 · S/N 15067302 N6503FStockton Ketron J · Bulls Gap, TNBuilt 1973 · S/N A1500446 N6503SElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1967 · S/N 15067303 N6504GHoward David D · Winner, SDBuilt 1970 · S/N 15072004 N6505FCoffman Curtis M · Lakeside, ORBuilt 1966 · S/N 15063105 N6505GStern Scot G · Escondido, CABuilt 1970 · S/N 15072005 N6506FMdowell Pilot Service LLC · South Hutchinson, KSS/N 15063106 N650VVMindy Limited LLC · Muscatine, IABuilt 1969 · S/N 17258561 N6510FPrice Gregory L · Kyle, TXBuilt 1966 · S/N 15063110

Back to AD 72-03-03 R3