OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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

N7510FGrand Canyon Flyers LLC · Flagstaff, AZBuilt 1969 · S/N 719N7511FEisenbrey Glen T · Greenbank, WABuilt 1969 · S/N 720N7512FCulver Marc D · Anchorage, AKBuilt 1969 · S/N 722N7512KLund James R · Champlin, MNBuilt 1950 · S/N 18-228N7513FFrank Jerry W · Vonore, TNBuilt 1969 · S/N 723-70N7515HWrabetz Michael J · Anchorage, AKBuilt 1946 · S/N 12-379N7515KHartman John E · Rangely, COBuilt 1950 · S/N 18-230N7516KMattie Joseph G · Ester, AKBuilt 1950 · S/N 18-233N7517KEckels Daniel R · Centerburg, OHBuilt 1950 · S/N 18-235N7518KHarris Hill Soaring Corp · Horseheads, NYBuilt 1950 · S/N 18-231N7519KErickson Roger · Hamill, SDFirst renewal noticeBuilt 1950 · S/N 18-234N751MDVaughn Billy D · Poteau, OKBuilt 2015 · S/N 75-8213N7521HKrochmal David R · Lancaster, PAS/N 12-385N7523KRichardson Joe W · Ennis, MTBuilt 1950 · S/N 18-239N7524HThree D Adventures LLC · Newfolden, MNS/N 12-388N7524KBartel Gordon L · Anchorage, AKBuilt 1950 · S/N 18-240N7525HN7525h LLC · Lincoln, VTBuilt 1946 · S/N 12-389N7527HBauer Dereck · Clinton, UTS/N 12-391N75282Aero-Mobil Inc · Wilmington, DEBuilt 1956 · S/N 1N752DEEwers C Donald Trustee · Batavia, OHBuilt 1998 · S/N 1368-98N7532HWatson Richard D · Anchorage, AKS/N 12-396N7534KSantana Joseph W · Waynesboro, VABuilt 1950 · S/N 18-250N7537HGuedon Aviation LLC · Natchez, MSBuilt 1946 · S/N 12-403N7537KDahl Roy L · Camp Crook, SDBuilt 1950 · S/N 18-254N7550KAmblin Antique Air Inc · Green Cove Springs, FLBuilt 1950 · S/N 18-266N7553BTri Star Aviation Inc · Nashua, NHBuilt 1977 · S/N A1520767N7556FWetzel Gehred · Factoryville, PABuilt 1969 · S/N 732-70N7558KCudworth Jay P · Sheyenne, NDBuilt 1950 · S/N 18-273N7558LBahinting Dan Brian M · Rosamond, CABuilt 1978 · S/N A1520819N7559FDodge Donald V · Newnan, GAS/N 208-70N7560FCitabria Club LLC · Baton Rouge, LABuilt 1969 · S/N 733-70N7561HZurcher Michael W · Newburg, NDBuilt 1946 · S/N 12-430N7562HGrigsby Guy P · Glenburn, NDS/N 12-431N7564KCameron James T · Seldovia, AKBuilt 1950 · S/N 18-279N7567HGuidici Aidan G · San Antonio, TXS/N 12-437N7569FMainero Tanner R · Chehalis, WABuilt 1969 · S/N 731-70N7569HCompton Steven · East Northport, NYBuilt 1946 · S/N 12-439N7570HSearles Lewis A Jr · Grafton, OHBuilt 1946 · S/N 12-440N7570KStrub Henry J · Dillingham, AKBuilt 1950 · S/N 18-285N7571HChristman Christopher D · Chugiak, AKBuilt 1946 · S/N 12-441N7573FDirks Daniel P · Seguin, TXBuilt 1970 · S/N 757-70N7573HSugden Richard M · Hallock, MNBuilt 1946 · S/N 12-444N7574HMiller Thomas L · Ennis, MTBuilt 1946 · S/N 12-445N7574KPhair David E · Dixfield, MEBuilt 1950 · S/N 18-291N7576HSerbagi Casey R · Andover, MABuilt 1946 · S/N 12-447N7576KPetersen Jacob R · Wasilla, AKS/N 18-293N7579HDolansky Edwin J · Youngstown, NYBuilt 1946 · S/N 12-454N757AAHeavy Metal Air LLC · Farmingdale, NYBuilt 1977 · S/N 15279575N757ABCallum James M · Newport, NHBuilt 1977 · S/N 15279576N757ADLong Island Aviators LLC · Seaford, NYBuilt 1977 · S/N 15279578
Back to AD 80-25-02 R2