OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N5294XCarrigan Roy K · Oak Grove, MNS/N 2220N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559N5295SAlzarqa Saleh A · Fairfax, VABuilt 1970 · S/N 28-26941N5296BRobertson Ca · Phoenix, AZS/N 1158N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050N5296PFlanagan Robert Howard · Willows, CABuilt 1958 · S/N 24-337N5296RB&R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 17263510N5297BHughes Shaman · Cedaredge, COBuilt 1956 · S/N 1159N5297RWaltman Jack J · Forbes, NDBuilt 1974 · S/N 17263511N5297WTausch Eddie W · Port Aransas, TXS/N 28-348N5297YBlotsky Jim Darin · Fargo, NDBuilt 1963 · S/N 18-8022N5298DMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 17272500N5298JBagamaspad Alan M · Reseda, CABuilt 1980 · S/N 17273758N5298KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274051N5298RMurray Wanda Joyce Trustee · Proctor, MTS/N 17263512N5298TPleasant Valley Aviation Inc · Bellefonte, PABuilt 1972 · S/N 28-7225396N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501N5298WAim High Aviation LLC · Coral Springs, FLBuilt 1962 · S/N 28-349N52993Journeys Aviation Inc · Boulder, COBuilt 1981 · S/N 17274654N5299DPremier Flight Center LLC · Hartford, CTBuilt 1979 · S/N 17272501N5299LSerafini Ronald S · Murphy, NCS/N 28-4601N5299SRichard Douglas G · Decatur, TXBuilt 1970 · S/N 28-26744N5299WPatterson Guy R Jr · Glencoe, KYBuilt 1962 · S/N 28-350N529CANeufeld Don I · Fairview, OKS/N 17269104N529FLSchwanfelder Patrick K · Clinton, CTBuilt 1971 · S/N 28-7125356N529LFEnterprise Aviation Services LLC · Albuquerque, NMBuilt 1976 · S/N 17267970N529MCRhoads Eric S · Costa Mesa, CABuilt 1981 · S/N 17274639N529RBBusby Ralph H III Trustee · Newport, ORBuilt 1960 · S/N TD-417N529SWFrick Kurtis W · Larned, KSBuilt 1973 · S/N 28-7305450N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741N52AAWebster Patrick Edward · Elk Grove, CABuilt 1975 · S/N MB-760N52ATPowell Michael R · Anchorage, AKBuilt 1977 · S/N 1003N52CAAllison Charles L · Park Rapids, MNBuilt 1993 · S/N 1335N52DKPierson Janice Trustee · Scio, ORBuilt 1975 · S/N DE892N52DMPetersen Stephanie Ann Trustee · Coronado, CABuilt 1963 · S/N E3B-624-2224N52ERFly Safe Southwest LLC · Vail, AZBuilt 1979 · S/N AA5B1095N52FKSixgun Aviation LLC · Eddyville, KYBuilt 1991 · S/N 1122N52FSGreseth Harold · Buffalo, MNBuilt 1972 · S/N 426-73N52HMMead Charles Reese · Lake Havasu, AZS/N HM045N52HWBurns Robert B · Placerville, CABuilt 1966 · S/N 28-3466N52HYNorstegaard Brian M · Gillette, WYBuilt 2003 · S/N 2220N52JHMonroe Scott E · Antelope, CABuilt 1981 · S/N 1N52JPBrush Wesley A · Sparks, NVBuilt 1983 · S/N 1235N52KBRisjan Randy D · Westfield, NYBuilt 1995 · S/N 272N52KKVon Sternbert Nicholas Josef · Valencia, CAS/N 17700563N52MRShealy Berry J · Augusta, GABuilt 1989 · S/N 1325N52RARennenkampf Erik J · Columbia, MDBuilt 1974 · S/N M-1626
Back to AD 80-04-03 R2