OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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.

N739WXAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17270875N739WYN739wy LLC · Cheyenne, WYBuilt 1978 · S/N 17270876N739WZWhisky Zulu Inc · Port Washington, NYFirst renewal noticeBuilt 1978 · S/N 17270877N739XA7550g LLC · Birmingham, MIS/N 17270878N739XCAllen Danny T · Jonesboro, LABuilt 1978 · S/N 17270880N739XKAirways Aviation Inc · Grand Rapids, MNBuilt 1978 · S/N 17270887N739XLFlyrjf LLC · Weirsdale, FLBuilt 1978 · S/N 17270888N739XMEnstad Ordell J · Goldendale, WABuilt 1978 · S/N 17270889N739XSGorman Patrick M · Deerfield, OHBuilt 1978 · S/N 17270894N739XTS O W Aviation LLC · Crystal River, FLS/N 17270895N739XUTraining Mission Aviation Inc · New Tripoli, PABuilt 1978 · S/N 17270896N739XVAmaro Mark S · Mi Wuk Village, CABuilt 1978 · S/N 17270897N739XWWhole Life Wellness Center · Alpine, TXS/N 17270898N739YESundance Air Services Inc · Alameda, CABuilt 1978 · S/N 17270906N739YHMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270909N739YMHeritage Aviation LLC · Ankeny, IABuilt 1978 · S/N 17270913N739YRF&O Flight LLC · Calhoun, GABuilt 1978 · S/N 17270917N739YURrrr Aviation LLC · Bryan, TXBuilt 1978 · S/N 17270920N739YWPettit Toby B · Morehead, KYBuilt 1978 · S/N 17270922N739YZSocal Aviation Inc · Chino, CABuilt 1978 · S/N 17270925N739ZCP&B Aviation LLC · Watkins, COBuilt 1978 · S/N 17270928N739ZGR & R Aero Services Llcc · Eden Prairie, MNBuilt 1978 · S/N 17270932N739ZHFreeflight Aviation LLC · Allentown, NJBuilt 1978 · S/N 17270933N739ZLLefebvre Jeffrey S · Kaneohe, HIBuilt 1978 · S/N 17270936N739ZNOur Jett LLC · Englewood, COBuilt 1978 · S/N 17270938N739ZPBlue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 17270939N739ZRJw Horton Aviation LLC · Rogers, ARS/N R18201021N739ZSPryor James A · Bottineau, NDS/N 17270942N739ZUMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270944N739ZWHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 17270946N739ZXN739zx Flying Association · Kent, WABuilt 1978 · S/N 17270947N739ZZR & R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 17270949N73ALHefel Lori A · Wichita, KSBuilt 1974 · S/N 177RG0559N73DXAj Airlift LLC · Arlington, MAS/N 2868N73FRWayman Luy LLC · Weston, FLBuilt 1979 · S/N 17273134N73JGMeyer Gordon W · Huber Heights, OHBuilt 1973 · S/N 122-74N73MSJohnson Kevin N · Bethpage, NYBuilt 1977 · S/N 17268932N73PAJones Brandon B · Saint Francisville, LABuilt 1973 · S/N 79-73N73PCMedearis Jeff W · Plevna, MTS/N 7ECA-48N73PPArew Aviation LLC · San Tan Valley, AZS/N 17261627N73PWWarren John M · El Paso, TXBuilt 1971 · S/N 17259809N73SDMedlock-Turek Patick Evan · Clifton, NJBuilt 1978 · S/N 20-1252N73TDWeber Michael Scott · Gonzales, LABuilt 1973 · S/N 278-73N73WPGemini 3 LLC · Cleves, OHS/N 17268849N73XDN73xd LLC · Houston, TXBuilt 2014 · S/N 1136-2014N7402VKendrick Brian S · Kerrville, TXS/N 22-1195N7405GStan And Amy Weyer Aircraft LLC · Punta Gorda, FLBuilt 1970 · S/N 17259105N7405VBarrett Ronald A Jr · Shreveport, LABuilt 1975 · S/N 22-1198N7406VEvans Steven M · Somis, CAS/N 22-1199N7407FFp Aircraft Holdings LLC · Alvord, TXBuilt 1999 · S/N 416-98
Back to AD 80-25-07 R1