Registered aircraft · 40,471

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N90774Miller Lynn H · Scottsdale, AZS/N 80927 N9077DLitzen Guide Service Inc · Kenai, AKBuilt 1958 · S/N 18-6443 N9077JStreuer Troy · Smithville, TXBuilt 1966 · S/N 28-3113 N9077KPacific Coast Aero Inc · Torrance, CABuilt 1977 · S/N 28-7816188 N90783Rudd Wayne G · Basalt, COBuilt 1982 · S/N 0290 N9078DChandelle Ltd · Brighton, COBuilt 1958 · S/N 18-6446 N9078JConner W Larry · Los Lunas, NMBuilt 1966 · S/N 28-3115 N9078VRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1968 · S/N 690002 N9078YParker Ron L · Melissa, TXBuilt 1970 · S/N 18-8908 N9079DThomas William C · Blanchardville, WIBuilt 1958 · S/N 18-6447 N9079JTestruth Gary R · Coarsegold, CABuilt 1966 · S/N 28-3116 N9079NFlorida State College At Jacksonville · Jacksonville, FLBuilt 1982 · S/N 0295 N9079TLuther David J Trustee · Saint Maries, IDBuilt 2001 · S/N 001 N9079VAbramson Derek J · Lancaster, CABuilt 1968 · S/N 690003 N907AGAntique Aircraft And Automobile LLC · Van Alstyne, TXS/N 22-7218 N907APWheeler David A · Kennewick, WAS/N AG5B-10001 N907AZN907az LLC · Miami, FLBuilt 1980 · S/N 17274436 N907BPBryant Stephen C · Anchorage, AKS/N 22-2431 N907CCOconnor Lloyd Thomas · Dillingham, AKS/N 9907CC N907CUDenny Roger A Jr · Eagle River, AKBuilt 2016 · S/N 02-1988 N907DTLanni Douglas W · Fairbanks, AKBuilt 2022 · S/N 0001 N907GPGittlein Paul A · Wasilla, AKBuilt 2010 · S/N 001 N907JConaway Jeffrey Scott · Anchorage, AKBuilt 1965 · S/N 18-8259 N907KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268575 N907LEAll Her Fault LLC · Fairbanks, AKBuilt 2004 · S/N 3623 N907MWaitman Bradley J · Wasilla, AKBuilt 2020 · S/N 001 N907PSBrock W Walker · Charleston, SCBuilt 1966 · S/N 28-3762 N907RUBlahut Michael · Anchorage, AKBuilt 1950 · S/N 18-192 N907STState Of Alaska Department Of Public Safety · Anchorage, AKBuilt 1960 · S/N 18-7262 N907TWCarpenter Orin C II · Anchorage, AKBuilt 2023 · S/N 0001 N907UTClaus Paul E · Chitina, AKBuilt 1957 · S/N 18-5547 N907WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17267907 N907WMSpano Darren M · Deville, LABuilt 1979 · S/N 18-8009038 N907XLLunenschloss Michael L · Anchor Point, AKBuilt 1976 · S/N 18-7609010 N9080DTrieber Steven M · Eastport, MEBuilt 1958 · S/N 18-6448 N9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1975 · S/N 17265930 N9081JPerkins Jimmy Keith · Lonoke, ARBuilt 1966 · S/N 28-3118 N9081LReed William B Trustee · San Jose, CABuilt 1970 · S/N 224-70 N90829Leading Edge Aviation Consultants LLC · Windsor, CTBuilt 1985 · S/N 28-8690011 N9082DLeahy Garry E · Van Wert, IABuilt 1958 · S/N 18-6450 N90839White Jake W · San Antonio, TXS/N 101 N9083DSachs Randy S · S Huntington, NYBuilt 1986 · S/N 28-8690050 N9083KShuey Robert D III · Albertville, ALBuilt 1977 · S/N 28-7890174 N9084FIsland Bound LLC · Dunedin, FLBuilt 1980 · S/N 172RG0352 N9085JBligh Michelle C · Oceanside, CABuilt 1966 · S/N 28-3122 N9085KSale Reported · Grayling, MISale reportedBuilt 1977 · S/N 28-7890175 N9085LBlanton Jeffrey D · Valley Center, KSBuilt 1970 · S/N 226-70 N9086DDarrow John K · Soldotna, AKBuilt 1958 · S/N 18-6460 N9086JBrogan William J · Port Matilda, PABuilt 1966 · S/N 28-3123 N9086KMedia Stew LLC · Carson City, NVBuilt 1977 · S/N 28-7890176

Back to AD 80-04-03 R2