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.

N4918YGrathwohl Air LLC · Bloomfield Hills, MIBuilt 1980 · S/N 21064046N49191Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281184N49194Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281186N49197Wilt Aviation Consulting LLC · Sebastian, FLBuilt 1977 · S/N 15281188N49199Wygant Amanda N · Copper Center, AKBuilt 1977 · S/N 15281189N4919FTice Denzil · Farmville, VABuilt 1979 · S/N 17273102N4919GRegistration Pending · Fairbanks, AKRegistration pendingS/N 17273466N4919PRiggs Charles A · Pembroke Pines, FLBuilt 1981 · S/N 15284841N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673N491MABelle Casa Sport LLC · Tarpon Springs, FLBuilt 2004 · S/N 957-2004N49202Skylogix Aircraft LLC · La Verne, CABuilt 1977 · S/N 15281191N4920GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273467N4920SExecutive Flyers Inc · Sacramento, CAS/N R18201459N49215Dukelow Thomas W · Bad Axe, MIBuilt 1979 · S/N 15283437N4921RBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18802438TN4921VFrumkin Mark Steven · Pittsburgh, PABuilt 1980 · S/N 172RG0416N49226Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1979 · S/N 15283439N4922BAvcorp Holdings Inc · Jackson, MIBuilt 1979 · S/N 15283706N4922DD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272398N4922GBishop Air LLC · Elk Grove, CABuilt 1979 · S/N 17273469N4922SNyrhinen Aki · Reno, NVBuilt 1980 · S/N R18201461N4922VHhd Aviation LLC · Hamilton, OHBuilt 1973 · S/N 172RG0417N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047N49230US Flight Academy International Inc DBA · Post, TXBuilt 1977 · S/N 15281205N4923DHarrier Aviation LLC · South Saint Paul, MNFirst renewal noticeBuilt 1979 · S/N 17272399N49249Krawczak Kyle C · Littleton, COBuilt 1979 · S/N 15283442N4925FA S Air LLC · Lantana, FLBuilt 1979 · S/N 17273103N4925GSchwenker David W · Queensbury, NYBuilt 1979 · S/N 17273472N4925KAlberts Nelson · Weatherford, TXBuilt 1979 · S/N P21000371N49260Youth Aeronautics Education Foundation · Mattaponi, VABuilt 1977 · S/N 15281209N49261Salem Oregon Flight Training LLC · Salem, ORBuilt 1977 · S/N 15281210N49268Fox John E · Boonville, CABuilt 1977 · S/N 15281213N49276Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281217N4927BAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283709N4927DGreenville Flight LLC · Greer, SCS/N 17272401N4927QWakefield Aircraft LLC · Cooperstown, NDBuilt 1976 · S/N 18802662TN4927SDaniel L Voiers · Hephzibah, GABuilt 1980 · S/N R18201466N49285Fullerton Airport Pilot Association · Fullerton, CABuilt 1979 · S/N 15283445N49288Wisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 15281226N4928BWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283710N4928EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271676N4928SJohnson Jeffrey S · El Dorado, CABuilt 1980 · S/N R18201467N49292Johnson Scott W · Saline, MIS/N 15283446N492SFSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 17268310N492WPAngel Aviation Inc · Peoria, AZBuilt 1979 · S/N 17272684N4930BSkyranch Knoxville Youth Inc · Knoxville, TNS/N 15283712N4930RSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802447TN4931BWojtowicz Tomasz · Bronx, NYBuilt 1979 · S/N 15283713N4931RRegistration Pending · Westhope, NDRegistration pendingBuilt 1975 · S/N 18802448TN49328Air Puerto Rico Corp · Aguadilla, PRFirst renewal noticeBuilt 1979 · S/N 15283448
Back to AD 80-25-07 R1