OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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.

N4153CJet Care Corp · Roseville, CAS/N R18200330N4154RScheuerman Gary F · Athelstane, WIBuilt 1979 · S/N 1138-79N4156YCummings Amelia D · Delta Junction, AKS/N 962-77N4157YMclean Garrett Thomas · Soldotna, AKS/N 1183-77N4159YBauer Aviation LLC · Reese, MIBuilt 1977 · S/N 23877N4160CNewman Holdings LLC · Dallas, TXBuilt 1978 · S/N R18200332N4161YWings Enterprizes Ltd Co · Yukon, OKBuilt 1977 · S/N 282-77N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77N4163YWachter Bruce A · Maryville, TNS/N 959-77N4164COld Blue Solutions LLC · Harvest, ALS/N R18200333N4164HRobertson James I · La Pine, ORBuilt 1978 · S/N 24-0623N4166CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N R18200334N41677Northern Aviation LLC · Palmer, AKBuilt 1973 · S/N 585-73N41678Dodge Donald V · Newnan, GAS/N 586-73N41680Tailwheel Adventures LLC · Orlando, FLS/N 396-73N41681Ralston Michael J · Calhoun, GABuilt 1973 · S/N 397-73N41683Ferraro Jeffrey T · Mckinney, TXS/N 976-73N41684Nenahlo Thomas L · Anchorage, AKS/N 588-73N41686Atx Aero LLC · Austin, TXBuilt 1973 · S/N 398-73N41688Breunig Gerald S · Newark, ILBuilt 1973 · S/N 977-73N4168YThree Point LLC · Lacon, ILBuilt 1976 · S/N 1185-77N41691Whiteknucle Aerobatics Inc · Blacksburg, VABuilt 1973 · S/N 591-73N41693Glasford John T · Rapid City, SDBuilt 1973 · S/N 979-73N41694Damiano Charles J · Orcutt, CABuilt 1973 · S/N 400-73N41695Guilfoyle Robert J · Shepherd, MTBuilt 1973 · S/N 593-73N41696Aaa Aviation LLC · Donalsonville, GABuilt 1973 · S/N 116-73N41698Collier James R · Castle Rock, COBuilt 1973 · S/N 980-73N416SDTailwheel Adventures LLC · Celebration, FLBuilt 1968 · S/N 191N416SSChristie Ian A H · Limon, COBuilt 1974 · S/N 721-74N416WTHigh Desert Flight Instruction LLC · Albuquerque, NMBuilt 1975 · S/N 17702355N41700Craven Mark C · Salome, AZBuilt 1973 · S/N 596-73N4170YCraig Jerome A III · Plantation, FLBuilt 1977 · S/N 284-77N4171HHanson Zane · Danville, INBuilt 1978 · S/N 24-0653N4172YColonels Flying Club · Princeton, MNBuilt 1976 · S/N 1186-77N4175CSalciccioli Christopher · Joshua Tree, CABuilt 1978 · S/N R18200336N4177A77 Aero Inc · Naples, FLBuilt 2021 · S/N 1480-2021N41797Valdes Eusebio · Miami, FLBuilt 1973 · S/N 117-73N41798Fried Dennis A · Selfridge, NDBuilt 1973 · S/N 515-73N417CBWings Over L A Aviation LLC · West Hills, CAS/N 15281010N417DKVitrella Steven E · Melbourne, FLBuilt 1974 · S/N 177RG0563N417DMKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 417-99N417SPTonys Aerial Service Inc · Great Bend, KSBuilt 1980 · S/N 1350-80N41800Mccully Heather L · Payson, AZBuilt 1973 · S/N 981-73N41801Freeman James E · Dalworthington Gar, TXBuilt 1973 · S/N 605-74N41802Trs Holdings LLC · Kalispell, MTBuilt 1973 · S/N 402-73N41803Minot Aero Center · Minot, NDBuilt 1973 · S/N 598-73N41804Beulen Brian V · Mesa, AZFirst renewal noticeBuilt 1973 · S/N 279-73N41805Fosdick Kenneth E · Plymouth, MABuilt 1973 · S/N 982-73N41807Reid Robert W DBA · Independence, ORBuilt 1973 · S/N 403-73N41808Noble Raymond D · East Windsor, CTBuilt 1973 · S/N 558-73
Back to AD 80-25-07 R1