Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291 N31XEverson Dustin J · Providence, RIBuilt 1992 · S/N 671-92 N31YFCharliefoxtrot LLC · Farmington, MOBuilt 2015 · S/N 1158-2015 N3200ERegistration Pending · Burlington, WIRegistration pendingBuilt 1978 · S/N 17271466 N3201GArdent Aviation LLC · Salt Lake City, UTBuilt 1978 · S/N 24-0565 N3201LFowler Scott A · Lakeland, FLBuilt 1978 · S/N 24-0566 N3202HRegistered aircraftS/N 524-73 N3203FChampagne Anthony J · Prairieville, LABuilt 1967 · S/N 670123 N3205FHawkins William J II · Saint Petersburg, FLS/N 680002 N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467 N3207EArmstrong Aviation LLC · New Orleans, LABuilt 1978 · S/N 17271468 N3207FGoodwin Winston L · Cypress, TXBuilt 1967 · S/N 670361 N320DDBronson Robert D Trustee · Prineville, ORBuilt 1972 · S/N 17261193 N320MMExplorer Aviation LLC · Birmingham, MIBuilt 1997 · S/N 1231-97 N320WLAustin Mark S · Cat Spring, TXBuilt 1978 · S/N 24-0523 N320WWForsythe Chad · Foresthill, CAS/N 24-3310 N3210PKilcullen Brian DBA · Fort Lauderdale, FLBuilt 1978 · S/N P21000027 N3211EApm Leasing LLC · Casper, WYBuilt 1978 · S/N 17271470 N3212CChambers Todd R · Brundidge, ALS/N 670513 N3212FMcdonald Ronald W · Olive Branch, MSBuilt 1967 · S/N 670005 N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512 N3214FPicker Larry L · Stanfield, ORBuilt 1967 · S/N 670007 N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514 N3215FWinick Scott R · Jay, VTBuilt 1967 · S/N 670008 N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515 N3216EChrabot Gerard S · Virginia Beach, VABuilt 1978 · S/N 17271471 N3216FPerry Edward Glen Trustee · Ozark, ARBuilt 1967 · S/N 670009 N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516 N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518 N3219FTop Flight Detail LLC · Middlebury, INS/N 670012 N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353 N321BCGeorge Nathan V · Dardanelle, ARS/N 370-95 N321BLWalls Bruce · Middletown, OHBuilt 1981 · S/N P21000792 N321BPCenturion Air Inc · Ridgewood, NJS/N 21063986 N321KLInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 24-1102 N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202 N321QPelco Aviation Inc · Hampton Bays, NYBuilt 1978 · S/N R18200438 N321RJGritter Richard J · Catlett, VABuilt 1977 · S/N 323-77 N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807 N3224CHassebrock John M · Colorado Springs, COBuilt 1978 · S/N R18200257 N3224FShaffer Aviation LLC · Keystone Heights, FLBuilt 1967 · S/N 670017 N3227CSnider Frederick A Jr · Morgantown, WVBuilt 1978 · S/N R18200258 N3227E3227e LLC · Jacksonville, FLBuilt 1978 · S/N 17271475 N322BFVann Russell B · Mangum, OKBuilt 1979 · S/N 17273231 N322DMMooney Pit LLC · Noblesville, INBuilt 1993 · S/N 24-3294 N322ERucinski Thomas · Paramus, NJBuilt 1992 · S/N 698-93 N322TLJubien Walter L Jr · Newport News, VABuilt 1982 · S/N 24-1265 N322WMHurren Norman J · Applegate, MIBuilt 1997 · S/N 1362-97 N3230FRegistered aircraftBuilt 1967 · S/N 670023

Back to AD 80-25-07 R1