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.

N401DTKairos Holdings LLC · Huntsville, ALBuilt 1981 · S/N 17275165N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490N401LALee Hunter · Colorado Springs, COBuilt 1965 · S/N 2949N401LSEl Paso Aero Inc · El Paso, TXBuilt 1982 · S/N 17275784N401MPFriend Ships · Lake Charles, LABuilt 1979 · S/N P21000280N401RKRegistered aircraftBuilt 1990 · S/N 24-1694-14N4021Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1979 · S/N 17272149N4026NSeiger T W DBA · Medford, ORBuilt 1968 · S/N 680021N4027NC2c LLC · Chesterfield, MOBuilt 1968 · S/N 680161N4035NTodd Steven G · Binghamton, NYBuilt 1968 · S/N 680162N4036NJestice Manuel P · Ryder, NDBuilt 1968 · S/N 680023N403SWheeler James · Shreveport, LABuilt 1980 · S/N P21000403N4044NLundquist Matthew Michael · Navarre, FLBuilt 1968 · S/N 680164N4045NPrivate Flights Inc · Harleysville, PABuilt 1968 · S/N 680025N4048HL Heureux Brett J · Eustis, FLBuilt 1980 · S/N 24-1019N4049HStrand Jeffrey F · Scottsburg, INBuilt 1980 · S/N 24-1020N4049NCulley Richard A · Scottsdale, AZBuilt 1968 · S/N 680166N404JEMedia Stew LLC · Carson City, NVBuilt 1993 · S/N 724-93N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702N404XXInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201624N4050NCrawford Reagan Matthew · Lumberton, TXBuilt 1968 · S/N 680026N4052HFair Bryan R · Rhome, TXBuilt 1980 · S/N 24-1022N4054HMoon Dawg LLC · Tijeras, NMBuilt 1980 · S/N 24-1023N4055HClark Todd A · Kalispell, MTBuilt 1980 · S/N 24-1024N4056HKirchner Matthew R · Dalton, MABuilt 1980 · S/N 24-1025N4057NMominee Jules T · Evansville, INBuilt 1968 · S/N 680027N4058HEllis Fife Baker · Cypress, TXBuilt 1980 · S/N 24-1027N4058NHancock Randall G · Evanston, WYBuilt 1968 · S/N 680168N405DTSkiles Carl A · Leander, TXS/N 17702389N405JHTss Flying Club Inc · Bethesda, MDBuilt 1981 · S/N R18201790N405RCWaterman David N · Amery, WIS/N 4-71N4060GCm3 LLC · North Las Vegas, NVS/N 17264771N4061NChristensen Kier · Scottsdale, AZBuilt 1968 · S/N 680028N4064HRac Enorian S · Destin, FLBuilt 1980 · S/N 24-1045N4065HGreen Brian Michael · Chapel Hill, NCBuilt 1980 · S/N 24-0985N4067HElliott Norman · Stillwater, OKBuilt 1980 · S/N 24-1046N4068NThomas Averett V · Greensboro, NCBuilt 1968 · S/N 680030N4069NGrady Kevin M · Spokane, WABuilt 1968 · S/N 680171N406ACLequire Paul D · Kingston, TNBuilt 1998 · S/N 406-98N406JKKolstad Jon C · Glasgow, MTBuilt 1976 · S/N 231-76N406PTMurray John J · Kalispell, MTBuilt 1981 · S/N 172RG0801N4071HDashiell Jeffrey A · Odessa, TXBuilt 1980 · S/N 24-1050N4073NBoswinkel Aviation Inc · Wilmington, DEBuilt 1968 · S/N 680031N4074HScheinpflug Larry R · Dunwoody, GABuilt 1980 · S/N 24-1053N4076NStewart Jason S · Hornell, NYBuilt 1968 · S/N 680172N407LALangewisch Gary R · Pasadena, CABuilt 1984 · S/N 24-1528N4083HJones Jeffrey W · San Antonio, TXBuilt 1980 · S/N 24-1057N4084HKremer Gabriel J · Fort Madison, IABuilt 1980 · S/N 24-1058N408JNTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1966 · S/N 58N4099NS O Witt And Associates LLC · Ridgecrest, CAS/N 680174
Back to AD 80-25-07 R1