Skip to content

Registered aircraft · 20,481

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.

N9185MGoddard Aircraft Club Inc · Crofton, MDBuilt 1976 · S/N 18264730 N9185TJones Justin · Wasilla, AKBuilt 1960 · S/N 50685 N91860Ransom Bob · Pasco, WABuilt 1969 · S/N 18259937 N91866Weldon Jeffrey A · Anacortes, WABuilt 1969 · S/N 18259939 N91868V12 Enterprises LLC · Niceville, FLBuilt 1969 · S/N 18259940 N9186HWicked Wings Aviation LLC · Dover, DEBuilt 1981 · S/N 18267926 N9186TEpi Technologies Inc · Antioch, ILBuilt 1977 · S/N 21062227 N9187CKd3262 LLC · Downers Grove, ILBuilt 1978 · S/N R18200439 N9187RMih LLC · Birmingham, ALBuilt 1978 · S/N R18200666 N9188CVail Jeffrey J · Rexburg, IDS/N 31287 N9188KGallion David B · Michigan City, INBuilt 1968 · S/N 18259164 N9188MSturgis Jason A DBA · Talkeetna, AKBuilt 1970 · S/N U20601588 N9189CJastram Benjamin C · Lafayette, LABuilt 1954 · S/N 31288 N9189MFinnegan Patrick T · West Lafayette, INS/N 18264733 N918CTBlinn Gilbert Trustee · Eastsound, WABuilt 1968 · S/N 18259387 N918MYFlying Pigs LLC · Tulsa, OKBuilt 2005 · S/N 18281512 N918TPAzure Quest LLC · Cleveland, TNBuilt 2007 · S/N 18281904 N918WMStone City Charters LLC · Anamosa, IABuilt 2008 · S/N 18282068 N91900Lewis Jeery K · Cocolalla, IDBuilt 1969 · S/N 18259942 N91907Skierka Christopher · Browning, MTBuilt 1969 · S/N 18259947 N9190CDickamore Chris E · Lewiston, IDBuilt 1962 · S/N 18051202 N9190MBgm Aero Inc · North Zulch, TXBuilt 1976 · S/N 18264734 N91912Champagne Estates Inc · Wilmington, DEBuilt 1969 · S/N 18259949 N91916Hanson Larry G · Seattle, WABuilt 1969 · S/N 18259950 N91917Fairchild Chad E · Logandale, NVBuilt 1969 · S/N 18259951 N9191CBash Dennis W Jr · Wasilla, AKBuilt 1954 · S/N 31290 N9191GFischer Gary H · Savannah, GAS/N 18260731 N91920Brodel Adam · Grass Valley, CABuilt 2007 · S/N 18281921 N91926Pacific Flying Association LLC · Aurora, ORBuilt 1969 · S/N 18259955 N91928Moseley Michael S · Chelsea, ALBuilt 1969 · S/N 18259957 N9192CBellamy Mark A · Freeville, NYBuilt 1955 · S/N 31291 N9192GWg Aero LLC · Shreveport, LABuilt 1971 · S/N 18260732 N9192MHandelin Gary W · Carson City, NVBuilt 1970 · S/N U20601592 N91937Munsell Kenneth L · Stuart, FLBuilt 1969 · S/N 18259961 N9193TRich Edward L · Liberty, UTBuilt 1960 · S/N 50693 N91941West Debra C · Dillon, COBuilt 1969 · S/N 18259963 N91942Marvelous Margies Flying Club LLC · Helper, UTS/N 18259964 N9194GJd Business Services LLC · Denair, CAS/N U20603808 N91950Bruno Cosimo Gino · Spokane, WABuilt 1969 · S/N 18259966 N91954Suchland Simon K · Fairbanks, AKBuilt 1957 · S/N 50105 N91958Greenwood Richard S · Duncan, OKBuilt 1969 · S/N 18259967 N91963Justpullin Inc · Wilmington, DEBuilt 1969 · S/N 18259970 N9196GJohnson Judith A · Sedro Woolley, WABuilt 1971 · S/N 18260736 N9196TC9196tango LLC · Kalispell, MTBuilt 1960 · S/N 50696 N91976Tucker Bobby G · El Dorado, ARBuilt 1969 · S/N 18259975 N91978Dvorak Ross E · Highland, CABuilt 1969 · S/N 18259976 N9197CWood Steven · Morgan, UTBuilt 1954 · S/N 31296 N9197GWheeler Dealer LLC · Wilmington, DEBuilt 1971 · S/N 18260737 N9197TRichardson Gordon P · Polson, MTBuilt 1960 · S/N 50697 N91987Sander William D · Eaton, COBuilt 1969 · S/N 18259982

Back to AD 84-10-01 R1