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.

N714WGWhitt Sana F · East Quogue, NYS/N 15279485N714WPWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279492N714WSR & D Aircraft Inc · Jamestown, NCBuilt 1977 · S/N 15279495N714WTJones Freda C · San Antonio, TXBuilt 1977 · S/N 15279496N714WWVess Gerald · Livingston, TXS/N 15279499N714XBWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279504N714XJSummit Aviation Holdings Of Nwa Inc · Rogers, ARBuilt 1977 · S/N 15279511N714XXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279524N714YKThurman Glen · Mineola, TXBuilt 1977 · S/N 15279536N714YWHiflite LLC · Athens, ALBuilt 1977 · S/N 15279547N714YXLone Star Aero Inc · Fort Worth, TXBuilt 1977 · S/N 15279548N714ZBRegistered aircraftBuilt 1977 · S/N 15279552N714ZCMauser William T · Rio Linda, CABuilt 1977 · S/N 15279553N714ZGNotam Aviation LLC · Portage Des Sioux, MOBuilt 1977 · S/N 15279557N714ZPDippold Lois M · Perry, MIBuilt 1977 · S/N 15279564N714ZUJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279569N714ZXWagner Michael · Winter, WIBuilt 1977 · S/N 15279572N714ZYCoco Aircraft Inc · Merritt Island, FLBuilt 1978 · S/N 15282152N71501Boone William G · Orland, CABuilt 1976 · S/N 17267228N7150SGabrial Aviation LLC · New Berlin, WIBuilt 1981 · S/N R18201699N7151GRoadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258851N7151JLenticularis LLC · Madison, WIBuilt 1980 · S/N 17273903N7151UGendrich Charles P · Middletown, CTBuilt 1964 · S/N 390N7151VDakota Ear Nose & Throat Clinic Pc · Green Bay, WIS/N 20-0038N71528Little John · Hamilton, TXS/N 7ECA-326N7152GJ&B Aircraft Leasing LLC · Lufkin, TXBuilt 1969 · S/N 17258852N7152QSkyrealms LLC · Austin, TXBuilt 1972 · S/N 17260452N7153USmith Coty C · The Colony, TXBuilt 1964 · S/N 392N7153VTamadon Farhad F · Chino Hills, CABuilt 1974 · S/N 20-0040N7154GJuranich William M · Kent, WAS/N 17258854N7155QValley Ltd Of Fayetteville · Fayetteville, NCBuilt 1972 · S/N 17260455N7155UProtze Mark · Anacortes, WABuilt 1964 · S/N 394N7155VRansom Michael J · Camby, INBuilt 1974 · S/N 21-0050N7156QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260456N7157GAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258857N7157USl Motorsports Inc · Paradise Valley, AZBuilt 1964 · S/N 396N7157VVictory David L · Toano, VABuilt 1974 · S/N 21-0052N7158GHawk Aviation Inc · Rush City, MNBuilt 1969 · S/N 17258858N7158UMenjivar Christian J · Missoula, MTS/N 648N7159GN7159g LLC · Jacksonville, ARS/N 17258859N7159UChamberlain Gary M · Challis, IDBuilt 1964 · S/N 398N7159VCm&D Holdings Inc · Honolulu, HIBuilt 1974 · S/N 21-0054N715ACLowther Fred · Corvallis, ORBuilt 2004 · S/N 1360-2004N715AMVon Graff Kurt · Pennington, NJBuilt 1993 · S/N 703-93N715GHodge Cle'Jae J · St Thomas, VIBuilt 1980 · S/N 172RG0653N715TLucy Roy · Ada, OKFirst renewal noticeBuilt 1977 · S/N 15279611N715USuper D Aviation LLC · Lafayette, ALBuilt 2013 · S/N 1134-2013N7160GFisher Noel F · Petersham, MABuilt 1969 · S/N 17258860N7160QPhoenix Aviation LLC · Meridian, IDBuilt 1972 · S/N 17260460N7161GJohnson Robert D · Denver, PABuilt 1969 · S/N 17258861
Back to AD 80-25-07 R1