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.

N9450XDavila R · Runge, TXS/N 21057750 N9451MSnow Jeffrey J · Mechanicsburg, PABuilt 1976 · S/N 18264766 N9451XRegistered aircraftS/N 21057751 N94527Kamer Joseph P · Topeka, KSBuilt 1978 · S/N 18266428 N94529Clary Daryl · Moorestown, NJBuilt 1978 · S/N 18266430 N9452GStokes Letta J · Chugiak, AKBuilt 1971 · S/N U20601652 N9452MSoares De Matos Guilherme Cesar · Fort Lauderdale, FLBuilt 1970 · S/N 21059352 N94531Cire Aviation LLC · Lutz, FLBuilt 1978 · S/N 18266431 N94536Freese Marc A · Fulda, MNBuilt 1978 · S/N 18266434 N94537Joyner Russell L · Aulander, NCBuilt 1978 · S/N 18266435 N94538Curran James · Santa Ana, CABuilt 1978 · S/N 18266436 N94539Woodward William R · Portland, ORBuilt 1978 · S/N 18266437 N9453CEarth Center Adventure Inc · Haines, AKBuilt 1955 · S/N 31851 N9453THansen Jerry E · San Antonio, TXBuilt 1960 · S/N 57253 N9453XFlying Machines LLC · Danville, CABuilt 1985 · S/N 18268530 N94544Dawson Farms · Tappen, NDBuilt 1978 · S/N 18266439 N94549Scott Nathan A · Lake Winnebago, MOBuilt 1978 · S/N 18266443 N9454XRoland Aviation LLC · Saint Matthews, SCBuilt 1985 · S/N 18268531 N9455XRather Be Airborne LLC · Chaska, MNBuilt 1985 · S/N 18268532 N9456CCoaker Martin · Ada, MIBuilt 1955 · S/N 31854 N9456XMoxie Holdings LLC · Midvale, UTBuilt 1985 · S/N 18268533 N9457XRoss Karen F · Marion, TXBuilt 1961 · S/N 21057757 N94587Kenny Douglas B · Auburn, NHBuilt 1978 · S/N 18266448 N94588Burt Lisa C · Justin, TXS/N 18266449 N9458TWasp Air LLC · Hamilton, MTBuilt 1960 · S/N 57258 N9458XAnderson William B · Rogers, ARBuilt 1961 · S/N 21057758 N94592Oklahoma State University · Stillwater, OKBuilt 1978 · S/N 18266452 N94596Koulbou Moussa A · Chandler, AZBuilt 1978 · S/N 18266455 N94598Klein Thomas Alan · North Pole, AKBuilt 1978 · S/N 18266457 N94599Ams Aviation LLC · South Bend, INBuilt 1978 · S/N 18266458 N9459MCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N U20604547 N945CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282407 N945EBFlying Z LLC · East Lansing, MIBuilt 1998 · S/N 18280137 N945FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1980 · S/N R18201484 N945GPrimewings Holdings LLC · Sunnyvale, CABuilt 2019 · S/N 18283067 N945PDHickmott Mark T · Sunol, CABuilt 2001 · S/N 18280945 N94608Hansen David A · Milton Freewater, ORBuilt 1978 · S/N 18266459 N94619Fanning Fred W · Fairlawn, OHBuilt 1978 · S/N 18266463 N9461GMillionair Inc · Ferndale, WAS/N U20601661 N9461MMaster Chief Cricket LLC · Morgan City, LABuilt 1970 · S/N 21059361 N9461REthnos360 Inc DBA · Mcneal, AZBuilt 1985 · S/N U20606868 N9461ZMichigan Aeronautics Commission · Lansing, MIBuilt 1981 · S/N U20606505 N94623Watts Mark A · Medicine Lodge, KSBuilt 1978 · S/N 18266464 N9462CAcp Aviation LLC · Oakdale, LABuilt 1955 · S/N 31860 N9463COgden Dale · Buckley, WABuilt 1955 · S/N 31861 N9463TMcbee Kenneth H · Pasadena, TXBuilt 1960 · S/N 57263 N94643Ashmore Mark D · Naples, IDBuilt 1978 · S/N 18266471 N94645Bozic Zeljko · San Pedro, CABuilt 1978 · S/N 18266472 N9464CSpencer Page Trustee · Anchorage, AKBuilt 1955 · S/N 31862 N9464M2morrow Aviation LLC · Abilene, TXBuilt 1977 · S/N 21062079

Back to AD 84-10-01 R1