OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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.

N1650RKock Berwin M Trustee · Grove, OKBuilt 1975 · S/N AA1B-0550N1651RThrasher Rodney L · Bartonsville, PABuilt 1976 · S/N AA1B0651N1652REwing Kneale Daniel · Tulsa, OKBuilt 1976 · S/N AA1B0652N1659GMills Kurt E · Oak View, CABuilt 1968 · S/N 632N165EZVissers Jacob A · Saint Peters, MOBuilt 1987 · S/N 165N1660GHintzman Bonnie L · New York Mills, MNBuilt 1968 · S/N 633N1661GLockbaum James G · Oconomowoc, WIBuilt 1968 · S/N 636N1664GTownsend Virgil P · Yukon, OKBuilt 1968 · S/N 645N1667GEngel Craig D · Amboy, INBuilt 1968 · S/N 640N1668GNewport Signal Air Inc · Anacortes, WAS/N 641N1669GTaylor Michael P · East Olympia, WAS/N 642N166DBStokes Lowell W · Kingwood, TXBuilt 1967 · S/N 276N166RSThiessen David · Brownsville, TXBuilt 1972 · S/N 876-72N166TBuechle Tim P · Talkeetna, AKBuilt 1953 · S/N 18-2280N1672GGivens Benjamin T · Ruffin, SCBuilt 1968 · S/N 643N1673GLake Robert F · Mechanicsville, MDBuilt 1968 · S/N 644N168HWClement Jim L · Baraboo, WIBuilt 2012 · S/N JC 12N1697GConnell Edward A · Crescent City, FLBuilt 1968 · S/N 581N1699GBeckham Samuel G · Saint Charles, MOBuilt 1968 · S/N 647N16EFAnything Aviation LLC · Fort Lauderdale, FLBuilt 1977 · S/N 15280441N16ERNeale Dorland F · Florence, ORBuilt 1977 · S/N 240N16JBRegistration Pending · Pawleys Island, SCRegistration pendingS/N 151N16MBLancaster Wesley A · Saint Augustine, FLBuilt 1961 · S/N 22-8387N16RRAustin Donald E · Ripley, MSBuilt 1979 · S/N 15283120N170DBBlanton David L · Valley Center, KSS/N IN170MLLacey David G · Locust Grove, GABuilt 1974 · S/N 1074-75N170SUTop Flight Consulting LLC · Fort Myers, FLBuilt 1979 · S/N 152-83248N171EMagerstadt David E · Rhome, TXBuilt 1970 · S/N 0-1N1721NWood Bokman Janine · Athol, IDBuilt 1946 · S/N 11965N172TMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1953 · S/N 18-2286N175RWMurphey Tyler · Waco, TXS/N 15N1766KDates Edmund H · Red Creek, NYBuilt 1946 · S/N 4493N177BDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281660N177CTLancaster Clinton · Gainesville, FLS/N AA1C-0016N178BABuck James · Christiana, TNS/N 38-78A0064N178JSTidd Scott · Reading, MIBuilt 1981 · S/N WA-230N17KATindeland Steve T · Corpus Christi, TXBuilt 2000 · S/N 20-0044N17NVLeseberg Mark E · Boulder City, NVBuilt 1946 · S/N 12-863N17RRRiverside Flight Center Inc · Tulsa, OKBuilt 1979 · S/N 15284134N1803GCarolina Aero Group LLC · Youngsville, NCBuilt 1968 · S/N 544N1804REssex Air LLC · Franklin Lakes, NJBuilt 1981 · S/N WA-269N1805GWilliams Roger A · Langford, SDBuilt 1968 · S/N 559N1805VMorais Omar · Spring, TXBuilt 1981 · S/N WA-270N1806GAmelia Reid Aviation LLC · San Jose, CABuilt 1968 · S/N 573N1807GCj Mosman & Son · Nezperce, IDS/N 565N1808GFleming Tod E · Davenport, WABuilt 1968 · S/N 570N1809GBerardi Christopher · Crowley, TXBuilt 1968 · S/N 571N180TWatanabe Masayuki · Harbor Oaks, FLBuilt 1953 · S/N 18-2294N1811GYelle Flyers LLC · Cashion, OKBuilt 1968 · S/N 584N1811KGage Lewis Trustee · Reno, NVBuilt 1946 · S/N 4538
Back to AD 80-25-02 R2