Registered aircraft · 26,232

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.

N803NGKingdom Air Corps · Sutton, AKBuilt 1946 · S/N 9689 N8040FWingfield Kyle M · Leesburg, GABuilt 1966 · S/N 15064140 N8040SNew Flight LLC · Dublin, VABuilt 1965 · S/N 15061640 N8040XMj Coop LLC · Sylva, NCBuilt 1961 · S/N 17248540 N8042LHigdem Dane Matthew · Kimberly, IDS/N 9367 N8042SBanning Braden L · Pleasant Hill, IABuilt 1965 · S/N 15061642 N8043SLund William R · Escondido, CABuilt 1965 · S/N 15061643 N8043XStrandberg Kevin L · Pennock, MNBuilt 1961 · S/N 17248543 N8044BAshley Ken E · Maiden, NCBuilt 1957 · S/N 29844 N8045ASalter James M · Crested Butte, COBuilt 1952 · S/N 20897 N8045LAmonett Rodney · Abilene, TXBuilt 1967 · S/N 17256245 N80461Bremer Wilfred P · Madison, WIS/N 7EC743 N8046BAnderson Charles D · Fairbanks, AKBuilt 1957 · S/N 29846 N8046SHolmes Gerald P · Billerica, MABuilt 1965 · S/N 15061646 N8047BGuidry Janice C · Mechanicsville, VABuilt 1957 · S/N 29847 N8047FPoole Terrell W · Rigby, IDBuilt 1966 · S/N 15064147 N8047XFitzgerald Jeff D · Smithfield, UTBuilt 1961 · S/N 17248547 N8048AWilson Earl William · Rockford, ILBuilt 1952 · S/N 20900 N8048BHohman Brent A · Larchwood, IAS/N 29848 N8048FParris Morgan Aaron R · Taylors, SCBuilt 1966 · S/N 15064148 N8048LFour Dudes And A Plane LLC · Whitehouse, OHS/N 17256248 N8049LPrewitt Murray L · Lake Jackson, TXS/N 17256249 N8049STri State Aero Inc · Martinsburg, WVBuilt 1965 · S/N 15061649 N8049TJasper Ann L · Las Vegas, NVS/N 56749 N804DCChrapczynski Daniel T · Sheffield Village, OHBuilt 2005 · S/N 1054 N804JABowser Adam L · Lake City, FLBuilt 2018 · S/N 001 N804PBFrazier Brian D · Jackson, MSBuilt 1950 · S/N 6734 N80500Swift Museum Foundation Inc · Athens, TNS/N 3 N8050LRobinette William B · Youngstown, OHBuilt 1967 · S/N 17256250 N8050SWeeks George E · Trenton, SCS/N 15061650 N8050TBeebe Steven J · Traverse City, MIBuilt 1960 · S/N 56750 N8051AB C Aviation LLC · Ketchum, IDBuilt 1952 · S/N 20903 N8051TSkylark Aircraft LLC · El Mirage, AZBuilt 1960 · S/N 56751 N8051XBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 17248551 N80523Riedel David W · Lebanon, OHBuilt 1946 · S/N 26 N80528Mastalerz Peter W · Monson, MABuilt 1946 · S/N 31 N8052XLafayette Aero Club Inc · West Lafayette, INBuilt 1961 · S/N 17248552 N8053AAero Aviation LLC · Summit, MSBuilt 1952 · S/N 20905 N8053FCurell Ken E · Centerville, OHBuilt 1966 · S/N 15064153 N8053LSasser Jeremiah · Ceres, CABuilt 1967 · S/N 17256253 N80540Mckinlay Jason S · Wareham, MAS/N 43 N8054ABarsamian Aaron · Sterling, AKBuilt 1952 · S/N 20906 N8054TAvey Richard D · Klamath Falls, ORBuilt 1960 · S/N 56754 N8054YStein Peter A · Georgetown, TXS/N 31569 N80555Stahla Russell A · Girdwood, AKBuilt 1946 · S/N 58 N8055BBraginetz Nathan Edward · Crozet, VABuilt 1957 · S/N 29855 N8055FGerken James D Jr · Salem, VABuilt 1966 · S/N 15064155 N8055LRowden Paul G · Wichita, KSBuilt 1967 · S/N 17256255 N8055SFoster Tommy L · Thaxton, VAS/N 15061655 N80564Weaver Tracey L · Cushing, OKBuilt 1946 · S/N 2001

Back to AD 94-05-05 R1