OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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-02-R2')
    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-02-R2')
  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.

N5243HKirk Douglas R · Benzonia, MIBuilt 1949 · S/N 16-47N5243QCas Ltd · Swanton, VTRegistration expired, pending cancellationBuilt 1981 · S/N 15285089N5243ZJinkins Richard D · Rewey, WIS/N 22-8925N5246QEast Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 15285092N5247XTexas Skies Flight School LLC · Boerne, TXBuilt 1969 · S/N 183N5247ZBard Alexander T · Portland, ORS/N 22-8930N5248ZTurner William J · Twentynine Palms, CABuilt 1961 · S/N 22-8931N5249ZCreger Paul L Jr · Springport, MIBuilt 1961 · S/N 22-8933N524HFBa Group LLC · Glastonbury, CTS/N 15283436N5250HPhilyaw Dale A · Lafayette, INBuilt 1949 · S/N 16-54N52525Mulderink Allen F · Watertown, WIBuilt 2023 · S/N 197N5253HBerry Milo A · Clarinda, IABuilt 1949 · S/N 16-57N5254XDahl Kevin A · Fargo, NDBuilt 1969 · S/N 704N5254ZPongracz Lajos Janos · San Antonio, TXBuilt 1961 · S/N 22-8939N5255HNorth Anthony · Rockwood, MEBuilt 1949 · S/N 16-59N5255ZGeorge James C · Lenoir, NCBuilt 1961 · S/N 22-8940N5256ZKirkpatrick Theodore J · Gwinn, MIBuilt 1961 · S/N 22-8941N5258BMathis Ryan B · Madison, ALS/N 15283818N5258HFrenzel Carl O · Midlothian, TXBuilt 1949 · S/N 16-62N525HFVintage Wings Aircraft LLC · Center Point, INBuilt 1977 · S/N 15280442N525RTLester Wm Curtiss · Martinsville, VABuilt 1969 · S/N AA1-0207N5260PKaufman Charles · West Palm Beach, FLBuilt 1981 · S/N 15284902N5260ZBerreman Jeffrey P · Yakima, WABuilt 1961 · S/N 22-8945N5261HTurner Edward J III · Mokena, ILBuilt 1949 · S/N 16-65N5261SSharp Russell E · Hartford, ALBuilt 2006 · S/N 4870N5261XPetri Howard R · Vincennes, INBuilt 1969 · S/N 712N5261ZKnight Lynn L · Pineville, LAFirst renewal noticeBuilt 1961 · S/N 22-8948N5263HWelch I Jay · Concrete, WABuilt 1949 · S/N 16-67N5263ZWilkins Jerry D · Toledo, WABuilt 1961 · S/N 22-8950N5264HRaichl Andrej L · Astoria, ORBuilt 1949 · S/N 16-68N5265HHarper Clayton E · Seabrook, TXBuilt 1949 · S/N 16-69N5265LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284283N5266HFritz Flying Service Inc · Lincoln, NES/N 16-70N5266LIlmberger Stephen R · San Leandro, CABuilt 1980 · S/N 15284284N526GGStocker Scott · North Las Vegas, NVBuilt 1978 · S/N 526N5271ZElliot Kirk R · Tulsa, OKBuilt 1961 · S/N 22-8963N5272ZScheda Mark R · Brockport, NYBuilt 1961 · S/N 22-8965N5276HYagcioglu Deniz S · Eatonton, GABuilt 1949 · S/N 16-80N5276MBruehl Kenneth · Roseville, CABuilt 1980 · S/N 15284513N5277HTurner Edward J III · Mokena, ILBuilt 1949 · S/N 16-81N5279HHarris Joe Paul Trustee · Goldsby, OKBuilt 1949 · S/N 16-83N527DCWeikart Samuel J · Leetonia, OHS/N 431N5282BStewart Ronald G · Douglas, MABuilt 1979 · S/N 15283826N5283ZRegistered aircraftBuilt 1961 · S/N 22-8978N5284HCampbell Peter R · Edgewater, FLS/N 16-89N5284ZRichard Waldren LLC · Newberg, ORBuilt 1961 · S/N 22-8980N5286PSzabo Arthur J · Hurley, NYBuilt 1981 · S/N 15284907N5289ZHenson Robert A · Mcloud, OKS/N 22-8985N528WAirplane Services Inc · Jay, FLBuilt 1978 · S/N 38-78A0693N5290NRunway 31 Inc · Lewes, DEBuilt 1994 · S/N 1
Back to AD 80-25-02 R2