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.

N8283NRuth Joyce Aviation LLC · Henderson, TXBuilt 1969 · S/N 28-25499 N8283VMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 28-8116065 N8283YPhillips Thaddus L · Knoxville, TNBuilt 1980 · S/N 28-8190064 N8284JCrouch Scott M · Steamboat Springs, COBuilt 1979 · S/N VAC-130-79 N8284NHolland Alan L · Houston, TXBuilt 1969 · S/N 28-25501 N8284WCaldwell Darrel R · Panama City Beach, FLBuilt 1965 · S/N 28-2443 N8285BHyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 28-8116066 N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171 N8285WBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2446 N8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeBuilt 1980 · S/N 28-8190073 N82864Meyer Fredric Kim · Orange, CABuilt 1982 · S/N 28-8316005 N8286CMidwest Sky Chasers Nfp · Algonquin, ILBuilt 1975 · S/N 28-7690110 N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172 N8286NAyyildiz Erol · Glen Rock, NJBuilt 1969 · S/N 28-25503 N8287Holloway Earnie G · Bonner Springs, KSBuilt 1972 · S/N 5231931 N8287BCostanti Nicolas J · Medford, ORS/N 18-7609048 N8287JBurnett Stephen B · Granby, MOBuilt 1979 · S/N VAC-133-79 N8287NBetik Patrick G · Grapevine, TXS/N 28-25504 N8288EGomez Cierra D · Jasper, ALS/N 17272174 N8288FAtwood Jason P · La Porte, INBuilt 1976 · S/N 28-7790237 N8288JRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1979 · S/N VAC-134-79 N8288ZPabon Hugo · Granada Hills, CABuilt 1980 · S/N 28-8116071 N8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 28-8116072 N8289JCummings Steven R · League City, TXS/N VAC-135-79 N8289XSheitelman Mitchell · Warren, NJBuilt 1980 · S/N 28-8190080 N828DMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N MCPHAIL-0001 N828JPCarney William F · Gallatin, TNBuilt 1957 · S/N 185460 N828LSKelly Ryan · New York, NYBuilt 1977 · S/N AA5A-0406 N828LUMuldrow Erik · Newport, KYBuilt 1958 · S/N 23-1373 N828MCHub City Aviation Academy LLC · Lubbock, TXBuilt 1968 · S/N 28-4615 N828YLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268168 N82905Reese Melissa A · Soldotna, AKBuilt 1977 · S/N 18-7709197 N82907Law Offices Of David Henderson · Anchorage, AKBuilt 1978 · S/N 18-7909031 N8290JSchaaf Rodney B · Bowman, NDBuilt 1979 · S/N VAC-136-79 N8290NHorne Larry E · Suffolk, VABuilt 1969 · S/N 28-25508 N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890 N8290WCastles James D · Portland, ORBuilt 1965 · S/N 28-2452 N82912Barrows Stuart L · Eagle River, AKBuilt 1977 · S/N 18-7709195 N82918Herman Brant · Fairbanks, AKBuilt 1977 · S/N 18-7809024 N8291ERangers Flying Club Inc · Eden Prairie, MNBuilt 1979 · S/N 17272177 N8291JWorth William A · Anthony, NMBuilt 1979 · S/N VAC-137-79 N8291NPeters Rodney A Jr · Hayward, WIBuilt 1969 · S/N 28-25509 N8291WVoll Dorothe A · Corona, CABuilt 1965 · S/N 28-2454 N82921New Hampshire Flying Association Inc · Nashua, NHBuilt 1982 · S/N 28-8390007 N8292DHuffman Jacob M III · Burleson, TXBuilt 1982 · S/N 28-8316009 N8292EP&N Corp · Marion, IAS/N 17272178 N8292JBrent Scott Properties Lp · Eagle, COS/N VAC-138-79 N8292WPinegar Kevin R · Brighton, MIBuilt 1965 · S/N 28-2455 N8293CMcchargue Robert W II · Talkeetna, AKS/N 18-4114 N8293EFiorini Anthony Wayne · Tuttle, OKBuilt 1979 · S/N 17272179

Back to AD 80-04-03 R2