Skip to content

Registered aircraft · 20,483

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N4062DJohnson Gunnar W · Unalakleet, AKBuilt 1958 · S/N 34762 N4063DRicheson Rodney Scott · Moses Lake, WABuilt 1957 · S/N 34763 N4067DBlackwood William C · Irvington, ALBuilt 1958 · S/N 34767 N4068YPatkotak Hugh G · Anchorage, AKBuilt 1962 · S/N 1850268 N406AHInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N 185-0442 N406CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282440 N406DPWings & Blades LLC · Columbia Falls, MTS/N 18051805 N406WMMcelvain Michael R · Billings, MTBuilt 1958 · S/N 51589 N4071DNew Richard A · Deming, WABuilt 1958 · S/N 34771 N4072YCompton Douglas C · Heron, MTBuilt 1961 · S/N 185-0272 N4073DKarsell Kris J · Duluth, MNBuilt 1958 · S/N 34773 N4074DDimitriadis Joseph T · Las Vegas, NVBuilt 1958 · S/N 34774 N4074YMcaleer John D · Aurora, ORBuilt 1961 · S/N 1850274 N4076YPhillips Halvor A · Winnemucca, NVBuilt 1961 · S/N 185-0276 N4077D234kq LLC · Eagle, IDBuilt 1957 · S/N 34777 N4077YWalker Air LLC · Charleston, WVBuilt 1977 · S/N 18265351 N4078DFinney James R · Howe, TXBuilt 1957 · S/N 34778 N4079DErnst Gregory R · Eagle Creek, ORBuilt 1957 · S/N 34779 N407CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282444 N4080DCrane Gary W · Gig Harbor, WABuilt 1957 · S/N 34780 N4080YPanama City Cycles Inc · Panama City, FLBuilt 1961 · S/N 1850280 N4081DEarl Tim G · Plymouth, CAS/N 34781 N4082DSharp Nicholas · Valdez, AKBuilt 1957 · S/N 34782 N4083DAerohawk Aviation Inc · Idaho Falls, IDBuilt 1957 · S/N 34783 N4086DThompson George M · Fairbanks, AKBuilt 1957 · S/N 34786 N4088DIron Horse Aviation LLC · Omak, WABuilt 1957 · S/N 34788 N4089DGaffney Justin L · Arcata, CABuilt 1958 · S/N 34789 N408CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282446 N408EAMagnell Gregory P Trustee · Vicksburg, MIBuilt 1998 · S/N 18280139 N408GHMcdowell Kevin A · Tumwater, WABuilt 1959 · S/N 57075 N408LJHuston Craig C · Keokuk, IABuilt 1975 · S/N 18264147 N408RStone Aviation LLC · Cusick, WABuilt 1954 · S/N 31149 N4090HSouthern Air Transport Services LLC · Dover, DEBuilt 1969 · S/N 18052083 N4093DZito Nick D · Ellensburg, WABuilt 1957 · S/N 34793 N4094DManker Lance M · North Platte, NEBuilt 1957 · S/N 34794 N4095DRedfern Ronnie M · Fairbanks, AKBuilt 1957 · S/N 34795 N4096DSkydive Cape Cod Inc · Caddo Mills, TXBuilt 1958 · S/N 34796 N4097PBarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280168 N4098DAspegren Robert N · Vacaville, CABuilt 1958 · S/N 34798 N409CQPaper Airplane Co LLC · Broomfield, COBuilt 2018 · S/N 18283041 N409CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282443 N40AESchwartz Michael · Missoula, MTBuilt 1964 · S/N 18255664 N40ASSchaad Rene · Arroyo Grande, CABuilt 1998 · S/N 18280422 N40ATN40at LLC · Lewis Center, OHBuilt 1978 · S/N R18200527 N40BBPawlak Jakub Piotr · Lafayette, INBuilt 1977 · S/N 18265944 N40BLK & B Real Estate Holdings LLC · Huntley, MTS/N 18264088 N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493 N40ECHill Richard C · Buckeye, AZS/N 18256692 N40GVHauser Paul J · Longmont, COBuilt 1976 · S/N U20603438 N40LSFenhaus Jason · Billings, MTBuilt 1973 · S/N 18262242

Back to AD 84-10-01 R1