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.

N4396QBennett Barry J · Owasso, OKBuilt 1971 · S/N 17260296N4397QWingsleasing LLC · Wichita, KSS/N 17260297N4397RBuiqui Aerospace Corp · Kissimmee, FLBuilt 1974 · S/N 17263147N4398RAlferman Thomas H · Hampton Bays, NYBuilt 1974 · S/N 17263148N4399QHoefly Christopher · Belleview, FLS/N 17260299N439ACCompton Dwayne H · Jennings, LABuilt 1999 · S/N 424-99N439MASpotto Michael A · Palmer, AKBuilt 2002 · S/N 439-2002N43ACThomas Air Service Inc · Hastings, NEBuilt 1991 · S/N 645-91N43APSchubert Edward M · Floyds Knobs, INS/N 17273802N43BPMichael W Miller LLC · Wilmington, DES/N 782-96N43CAThomas Nicholas O · Columbus, KSBuilt 1977 · S/N 24-0270N43CPMountain View Industries LLC · Missoula, MTBuilt 1979 · S/N P21000398N43DHHenderson Dwight D · Cape Coral, FLBuilt 1964 · S/N 283N43EAVisionary Holdings LLC · Missoula, MTBuilt 2026 · S/N 1230-2026N43FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17270808N43GBHenze Stacy A · Longmont, COS/N 769-96N43GFGaskins Joseph Spencer · Port Orchard, WABuilt 1980 · S/N 17274453N43JAJersey Aero Club · Lakewood, NJBuilt 1984 · S/N 24-1519N43MEEvans Matthew B · Granbury, TXBuilt 1978 · S/N P21000046N43MTEcho Tango LLC · Greensboro, NCBuilt 1997 · S/N 402-98N43WJHughes Todd R · Rocky Ford, COBuilt 1972 · S/N 318-72N4400RBophades LLC · Fort Pierce, FLBuilt 1974 · S/N 17263150N4402JBruton Paul · El Campo, TXBuilt 1980 · S/N T18803736TN4402QSummers Mark A · Alpine, WYBuilt 1973 · S/N 17261697N4402RAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17263152N4403RGorge Aviation Services LLC · Portland, ORS/N 17263153N4405RBon Homme Flyers Inc · Tyndall, SDBuilt 1974 · S/N 17263155N4407QSund Manufacturing Co · Newburg, NDS/N 17261698N4409RRegistration Pending · Albany, ORRegistration pendingBuilt 1974 · S/N 17263158N440ACColeman Ben · Lakeland, FLBuilt 1997 · S/N 1364-97N4410QAyer Benjamin D · Newport, MEBuilt 1973 · S/N 17261699N4410RSpane John T · Mount Airy, NCBuilt 1974 · S/N 17263159N4413HCharlton Jeremiah · Rockford, ILBuilt 1978 · S/N 24-0728N4413SBirmingham Flight Center LLC · Birmingham, ALS/N 17257905N4415RNextgen Flight Academy Inc · Riverside, CABuilt 1974 · S/N 17263163N4418RTeton Leasing LLC · Pocatello, IDBuilt 1974 · S/N 17263166N441ACAero Champ LLC · Orlando, FLS/N 401-97N441AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1983 · S/N 17276091N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691N441WSFord Mark L · New Cambria, KSBuilt 1966 · S/N 670049N4420RPeterson Reid E · Minnetonka, MNBuilt 1974 · S/N 17263167N4422HWitherspoon Brian · Ben Lomond, CABuilt 1978 · S/N 24-0729N4422NValiair Lc Trustee · Casper, WYBuilt 1978 · S/N P21000099N4422RN4422r LLC · Miami, FLBuilt 1974 · S/N 17263168N4422TMooney22t LLC · Kalispell, MTS/N 305N4423QObap · Westchester, ILBuilt 1973 · S/N 17261704N4423RAviation Specialists Inc · Gonzales, LABuilt 1978 · S/N R18200597N4424RBazemore Bryan P · Charlotte, NCBuilt 1978 · S/N R18200598N4427RRedwood Aviation Group LLC · Santa Rosa, CABuilt 1974 · S/N 17263173
Back to AD 80-25-07 R1