Registered aircraft · 26,230

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N1389FBedford Aero Club Inc · Bedford, INS/N 17254884 N138CLawrence Technological University · Southfield, MIBuilt 1949 · S/N 1 N138JJWard Gary P · Lincolnton, GABuilt 1946 · S/N 8035 N138LKnudsen Ernest William Jr · Ennis, TXBuilt 1967 · S/N R1 N138WWCutler Christopher P · Whitewright, TXBuilt 1954 · S/N 26189 N1390BSowers Harry D · S Bloomingvil, OHBuilt 1948 · S/N 6017 N1390EPancake C William Jr · Keyser, WVBuilt 1946 · S/N 7AC-4951 N1390YMarshall Greg J · Alexandria, VABuilt 1961 · S/N 17249090 N1391HFronhofer Mark · Franklin, VTBuilt 1949 · S/N 15AC-442 N1391QPark Derek B · Lyons, GABuilt 1971 · S/N 15072691 N1392BGrinder Michael C · Fairfield, PABuilt 1948 · S/N 6019 N1392DChalender Robert Christopher · Cocoa, FLS/N 19968 N1392QRegistered aircraftBuilt 1971 · S/N 15072692 N1392YDoty Douglas C · The Dalles, ORBuilt 1961 · S/N 17249092 N1393QBeitel Ronald Lee · Rochester, MNBuilt 1971 · S/N 15072693 N1393YHall Bret C · West Plains, MOBuilt 1962 · S/N 17249093 N1394FWeller Fred R · Saint Augustine, FLBuilt 1966 · S/N 17254889 N1394QDaugherty Keith C · Venus, PABuilt 1971 · S/N 15072694 N1395YEisele William Robert · Alt Loma, CABuilt 1961 · S/N 17249095 N1396DFlying Dutchman Aviation LLC · Richmond, TXBuilt 1951 · S/N 19972 N1396HRiggin Flight Service Inc · Madison, SDS/N 15AC-447 N1396YGarrison Shannon · Pangburn, ARS/N 17249096 N1397YMeyer Richard L · Fort Wayne, INBuilt 1961 · S/N 17249097 N139ANarus J J II · Georgetown, TNBuilt 1947 · S/N 7BCM129 N139BTTaylor Edward S · Billings, MTBuilt 1957 · S/N 29707 N139EZKoerner Brian J · Maineville, OHBuilt 1977 · S/N 139 N13AFJohnson Jimmy L · St Charles, MOBuilt 1975 · S/N 1364 N13AQGreat Lakes Aero LLC · Green Bay, WIBuilt 2008 · S/N CC11-00078 N13BALong Arthur · Colonie, NYBuilt 1975 · S/N 15077300 N13BBGoodwin William W · Pleasureville, KYBuilt 1949 · S/N 15234 N13CLCrawford Dennis E · Williams, ORBuilt 1946 · S/N 1985 N13CQCajun Queen 8a LLC · Ormond Beach, FLBuilt 1946 · S/N 3867 N13DRSchuler Edward A Jr · Hamden, CTFirst renewal noticeBuilt 1966 · S/N 15064816 N13DXDowling Dennis P · Newfields, NHS/N 27 N13HCinquanta Matthew D · Sherman Oaks, CABuilt 1974 · S/N JC-2 N13HSGregg Brian L · Guthrie, OKS/N F-039 N13JFFosgate Holdings LLC · Libby, MTBuilt 2015 · S/N 75-8731 N13JXHanselman Ronald L Jr · Cresson, TXBuilt 2005 · S/N AL-1008 N13LEStine Donny E Jr · Poplar Grove, ILS/N 17571 N13MWPorter Randall L · Athol, IDBuilt 1980 · S/N 1114 N13TGKantor Louis Falk · Charlotte, NCBuilt 2023 · S/N TX-1027 N13WUAchttien Kim Robert · Mohave Valley, AZBuilt 1977 · S/N 1166 N13XPOn And Clear LLC · Gillette, WYBuilt 1985 · S/N 2 N13XVParker Rob · Oklahoma City, OKBuilt 2015 · S/N 001 N1400BIler Elden · Van Nuys, CAS/N 6027 N1400FBingham Edward K · Buchanan, GABuilt 1966 · S/N 17254895 N1400UTino Frank V Jr · Miami, FLBuilt 1960 · S/N 15059024 N1401BSummers Greg D · Sheridan, ORBuilt 1948 · S/N 6028 N1401DRegistered aircraftBuilt 1951 · S/N 19984 N1402BSlys Aircraft Service · Platte, SDBuilt 1948 · S/N 6029

Back to AD 94-05-05 R1