OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,368

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.

N9333MMalaka Air LLC · Bradenton, FLBuilt 1966 · S/N 1265N93342Metro Technology Centers Aviation Career Campus · Oklahoma City, OKBuilt 1981 · S/N 15285471N9334HFree State Flying Club · College Park, MDBuilt 1975 · S/N 17266092N9334MLee Gary L · Aberdeen, IDBuilt 1966 · S/N 1266N9334RMirolla Michael · Lake Balboa, CABuilt 1979 · S/N R18200692N9334VSwope William T · Georgetown, OHS/N 700003N9335MPerry Christopher T · Eugene, ORBuilt 1966 · S/N 1267N9336MRioux Roger J · Corpus Christi, TXBuilt 1966 · S/N 1268N9337EMarianas Air Transfer Inc · Saipan, MPBuilt 1979 · S/N 17272230N9337HLorraine'S Blue Sky Aviation LLC · Norman, OKBuilt 1975 · S/N 17266095N9338BTopp Jason · Grace City, NDBuilt 1981 · S/N 172RG0799N9338HSchab Davis Maragaret A · Spangle, WABuilt 1975 · S/N 17266096N9338RMeshinsky Jeffrey · Alpine, CABuilt 1978 · S/N R18200693N9338VDheedene Nicholas · San Mateo, CABuilt 1969 · S/N 700004N93397Jet & Rotor Aviation LLC · Sacramento, CABuilt 1981 · S/N 15285479N9339VTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 700005N933AZN933az LLC · Miami, FLBuilt 1980 · S/N 15284626N933BCPathak Rahul · Mercer Island, WABuilt 2024 · S/N 1219-2024N933SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280526N93407Board Of Trustees DBA · Murphysboro, ILFirst renewal noticeBuilt 1981 · S/N 15285481N9340MWeidner Mark · Cincinnati, OHBuilt 1966 · S/N 1272N9341HAndreas Neil A · Yakima, WABuilt 1975 · S/N 17266099N9341MGabel Mark E · Oxnard, CABuilt 1966 · S/N 1273N9341TWilliams Norman L · Ennis, TXBuilt 1978 · S/N 38-78A0048N9341VAvalle Oscar A · Chicago, ILBuilt 1969 · S/N 700006N9342HGutierrez Ricardo · Downey, CABuilt 1975 · S/N 17266100N9342RCampbell Gene H · Baytown, TXBuilt 1978 · S/N 17702752N9342VClute Charles J · New Smyrna Beach, FLBuilt 1969 · S/N 700005N93434Silver Express Co DBA · Miami, FLBuilt 1982 · S/N 15285486N9343DAva Aviation LLC · Tappan, NYBuilt 1982 · S/N 172RG1128N9343MStateline Trucking Inc · Fruita, COBuilt 1966 · S/N 1275N9343VFundora Joel A · Altamonte Springs, FLBuilt 1969 · S/N 700007N93444Sullivan Wayne · Rockport, TXS/N 15285491N9344HBarnstormers Flying Club Inc · Pulaski, TNBuilt 1975 · S/N 17266102N9344LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276543N9344VOchoa Hougan Michael H · Chino Hills, CABuilt 1970 · S/N 700052N93454Marsh John E · Washington, DCBuilt 1982 · S/N 15285494N9345LHaynie Aviation LLC · Alexander City, ALBuilt 1986 · S/N 17276544N9345MMichael Matthew C · Ames, IABuilt 1966 · S/N 1277N9345VBroussard Troy A · Dickinson, TXS/N 700008N93468Bestway Transport LLC · Raymond, NES/N 15285496N9346DHolloway James H · Merritt Island, FLBuilt 1982 · S/N 172RG1129N9347HWings Like Eagles LLC · Wilmington, DEBuilt 1975 · S/N 17266105N93488Rawareo LLC · Warsaw, MOBuilt 1982 · S/N 15285501N9348HDeshazer Bill G · Gladewater, TXBuilt 1975 · S/N 17266106N9348MSauter Ross S · Cleveland, OKBuilt 1966 · S/N 1280N9349RMccelvey James L · Dilley, TXBuilt 1978 · S/N R18200694N934GRGrossman Robert W · Andover, MABuilt 1977 · S/N 17269688N934TRAris Leasing Inc · Sunnyvale, CABuilt 1977 · S/N 17269190N9350MPella Technology Services Inc · Pella, IABuilt 1966 · S/N 1282
Back to AD 80-25-07 R1