OpenAirDocs.org
AD 80-04-03 R2

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
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.

N8569CRudd Wayne G · Basalt, COBuilt 1954 · S/N 18-2720N8569DRegistration Pending · Willow, AKRegistration pendingBuilt 1958 · S/N 18-6223N8569VMachen Paul Stewart · Tallulah, LABuilt 1974 · S/N 795-75N856KWrong Brothers LLC · Sedgwick, KSBuilt 1997 · S/N 9608100N856KWMurphy Michael J · Mendota Heights, MNS/N 188N856NDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 4495001N8570CMoos Jacob W · Dillingham, AKBuilt 1953 · S/N 18-2722N8570VJ K Air Inc · Chaffee, NYFirst renewal noticeBuilt 1974 · S/N 308-75N8571VFlywyo LLC · Kalispell, MTBuilt 1974 · S/N 1072-75N8573COcean Aerial Ads Inc · Ocean City, MDBuilt 1953 · S/N 18-2726N8573VSchrack Kevin · Loganton, PABuilt 1974 · S/N 796-75N8574CVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2728N8575VMcintyre Jon D · Fairbanks, AKBuilt 1975 · S/N 142-75N8576YCenterline Holdings LLC · Belgrade, MTS/N 18-8889N8577Burke Jeremy D · Westminster, COBuilt 1964 · S/N 2737N8577VHoran Spraying LLC · Plainview, TXBuilt 1974 · S/N 309-75N8578CRiver Valley Flyers LLC · West Hartford, CTBuilt 1976 · S/N 28-7690152N8578DCoy Shane A · Nenana, AKBuilt 1958 · S/N 18-6236N8578VNelson Timothy E · Fairbanks, AKBuilt 1974 · S/N 143-75N8579Ralls Eddie · Evergreen, ALBuilt 1973 · S/N 457-73N8579CSolberg John W · Bismarck, NDBuilt 1953 · S/N 18-2732N8579NWillaero LLC · Union City, TNBuilt 1971 · S/N 28-7105133N8579VWalsh Leo A Jr · Anchorage, AKBuilt 1974 · S/N 797-75N857JWWarren Joseph A · Milford, DEBuilt 1963 · S/N 2435N857SSjs Aviation Co · Casper, WYBuilt 1981 · S/N 28-8190224N8580DKedrowski James L · Wasilla, AKBuilt 1958 · S/N 18-6238N8581DDutch Air LLC · Kalispell, MTBuilt 1957 · S/N 18-6239N8581VObx Airplanes LLC · Manteo, NCBuilt 1975 · S/N 805-75N8582JMarchione Laverne R · Diamondville, WYBuilt 1967 · S/N 15066482N8583VMorten John E DBA · Larimore, NDBuilt 1975 · S/N 145-75N8583YGray Michael W · Cheyenne, WYBuilt 1968 · S/N 30-1736N8585DMadsen Travis E · New Underwood, SDBuilt 1957 · S/N 18-6244N8587BDorsey Tony A · Anchorage, AKBuilt 1958 · S/N 36287N8587DSouthard Bryan O · Moneta, VABuilt 1957 · S/N 22-5766N8587VCaprock Soaring Association · Littlefield, TXBuilt 1974 · S/N 146-75N8588BSavage James B · Gibsonia, PABuilt 1975 · S/N 28-7525332N8588ELongaker Aviation LLC · Salem, VABuilt 1991 · S/N AG5B-10011N858KMAbsten Aviation LLC · Ashville, OHBuilt 1998 · S/N 21896N858RLLeto Richard G · Parker, COBuilt 2021 · S/N 828N858SFlying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0636N858SBBusch James David · Tempe, AZBuilt 2001 · S/N 20030N858SMLoomer Donald W · Williston, NDBuilt 1982 · S/N 28-8290079N858TVwf Enterprises LLC · Coppell, TXBuilt 2002 · S/N 81285N8590YNorthern Aviation LLC · Palmer, AKBuilt 1968 · S/N 30-1641N8591DConservative Three LLC · Taft, CABuilt 1958 · S/N 18-6251N8592NSluder George L · Willard, NCBuilt 1971 · S/N 28-7125434N8592VWest Michigan Aviation Academy · Grand Rapids, MIS/N 149-75N8593DTravis Charles E · Fairbanks, AKBuilt 1958 · S/N 18-6256N8594Campbell Jaret R · Watertown, SDBuilt 1973 · S/N 459-73N8594CNagia Omar Mohamed · Richmond, CAS/N 28-7625125
Back to AD 80-04-03 R2