OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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-25-07-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:80-25-07-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.

N8646VGautnier Mark A · Fairbanks, AKBuilt 1975 · S/N 1089-75N8647Ober John A · Candor, NYBuilt 1973 · S/N 355-73N8647VSpratling Boyd M · Deeth, NVS/N 818-75N8648VBeachy Phil R · Bonners Ferry, IDS/N 16575N8649Dudley Benjamin H · Wasilla, AKS/N 462-73N864JBouchard Cary T · Washburn, WIBuilt 1975 · S/N 864-75N864PAMorris David · Fort Mill, SCBuilt 1982 · S/N 172RG1063N864TWTailwinds Academy Of Aviation · Philadelphia, PABuilt 1972 · S/N 17261013N8653Rempel Warren K · Longmont, COBuilt 1973 · S/N 356-73N8653VLarson Paul E · Palmer, AKBuilt 1975 · S/N 838-75N86571Houck Steven E · Fairbanks, AKFirst renewal noticeBuilt 1973 · S/N 633-74N86573Phoenix Aviation Services Inc · Miami, FLBuilt 1973 · S/N 132-74N86574Kern Hunter S · Anchorage, AKBuilt 1973 · S/N 634-74N86576Pirkle Anthony E · Theodore, ALS/N 436-74N86578Halpin Aviation · Eden Prairie, MNBuilt 1973 · S/N 133-74N86579Youngs William D Jr · Moravia, NYS/N 420-74N8657VFrahm Michael T · Willow, AKBuilt 1975 · S/N 821-75N86582Sale Reported · Oxford, IASale reportedBuilt 1973 · S/N 638-74N86583Merrell Glen R · Eatonton, GABuilt 1973 · S/N 1004-74N86585Birchler Judy A · Indianapolis, INBuilt 1973 · S/N 134-74N86588Roberts Todd L · Friday Harbor, WABuilt 1974 · S/N 421-74N86591River Aviation Consulting LLC · Lake Havasu City, AZBuilt 1974 · S/N 1023-74N86592Landry Matthew A · Soldotna, AKBuilt 1974 · S/N 1022-74N86594Beadle Scott · Fort Worth, TXBuilt 1973 · S/N 1006-74N86595Coker Janie K · Tyler, TXBuilt 1973 · S/N 136-74N86605Gibbons Warren · Toledo, OHBuilt 1973 · S/N 288-74N86607Yellow Decathlon LLC · Algonquin, ILBuilt 1973 · S/N 138-74N8660VStaton Brian L · Lonoke, ARBuilt 1975 · S/N 314-75N86612Sale Reported · Wilmington, DESale reportedBuilt 1973 · S/N 1008-74N86617Teeters Esme · Duncansville, PABuilt 1974 · S/N 676-74N8662Corthell Andrew W · Andover, MNBuilt 1973 · S/N 920-73N86621Colson Carl · Blunt, SDBuilt 1973 · S/N 645-74N86625Ready Aim Flyer LLC · New Castle, DEBuilt 1973 · S/N 646-74N8662VMaxon Raymond D · Santa Paula, CAS/N 1091-75N8663Ireland Kel · Fredericksburg, TXBuilt 1973 · S/N 76-73N86630Pressley Aviation LLC · New London, NCBuilt 1974 · S/N 140-74N86633Gregor John E · Fairbanks, AKS/N 682-74N86634Shipp Donald E · Wyoming, MNBuilt 1973 · S/N 1012-74N86636Olson Kenneth L · Raymond, WABuilt 1973 · S/N 648-74N86637Stohr Beuford G · Woden, IABuilt 1974 · S/N 141-74N8664Page Jason · Medina, TNBuilt 1973 · S/N 463-73N86641Aa Stearman LLC · Lewisville, TXBuilt 1974 · S/N 427-74N86642Tedstrom Robert E · Bartlesville, OKBuilt 1974 · S/N 1025-74N86647Reuhl Kenneth R · Piscataway, NJS/N 295-74N8664VCollum Aviation LLC · Milton, FLBuilt 1975 · S/N 169-75N86651Wilbur Andrew E · Boyd, WIS/N 439-74N86654Dillard Ronald G · Lebanon, TNBuilt 1974 · S/N 1014-74N8665VMaisel Chad L · Plano, TXBuilt 1975 · S/N 193-75N8667VBloomquist Ronald D · Mooresburg, TNBuilt 1975 · S/N 17075N8668Freppon Farm Equipment LLC · Wilmington, DEBuilt 1973 · S/N 921-73
Back to AD 80-25-07 R1