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.

N218MAHospodar Robert P · Georgetown, PAS/N 2N218TSullivan Ross A · Saint Helena, CABuilt 1953 · S/N 18-2332N218ZMSkylink Xpress Inc · San Bernardino, CABuilt 1977 · S/N 15280011N219TCMendenhall Mont L · Thomasville, NCBuilt 1972 · S/N FGC-1000N21DYElliott Brandon D · Barstow, CAS/N AA1-0431N21HTZucconi Anthony Joseph · New Orleans, LABuilt 1979 · S/N 38-79A0806N21KKyle Howard C Jr · Brenham, TXS/N 544N21LMizer James D · Hailey, IDBuilt 1967 · S/N 111N21VXSisco Avery · Amarillo, TXBuilt 1982 · S/N 345N2202TColeman Shawn P · Ontario, ORBuilt 1987 · S/N 2202N220MLSaegaert Daniel G · Locust Grove, GABuilt 1968 · S/N 7ECA-651N2215KHubble Thomas A · Odessa, TXBuilt 1947 · S/N 4942N221TMee Dennis M · Portsmouth, NHBuilt 1953 · S/N 18-2335N221YMinolli Gregg A · Chelan, WABuilt 1968 · S/N AA1-0005N222FRGrusinski Joel A · Henderson, NVBuilt 1972 · S/N AA1B-0002N222UKCantine Steven L · Kotzebue, AKBuilt 1991 · S/N 2210N2231KBishop Elijah Ar · Ukiah, CABuilt 1947 · S/N 4958N223TFalconeri Michael A · Ketchikan, AKS/N 18-2337N223YDavis Tommy J · Ridgeville, SCS/N AA1-0011N2247NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N 12483N224SSQuesnel Joseph P · Middlebury, VTS/N AA1A-0433N224XPNichols Michael H · Thompson Falls, MTBuilt 2012 · S/N 6-8554N2255VPrice Tracker C · Hattiesburg, MSBuilt 1948 · S/N 14486N226TMcallister Hunter · Medford, ORBuilt 1953 · S/N 18-2340N2275EKircher Wayne E · Yorba Linda, CABuilt 1946 · S/N 7AC-5849N2279FUtz Joel Samuel · Austin, TXBuilt 1978 · S/N GC-1N227EZLeonard Nick A · Pipe Creek, TXBuilt 1988 · S/N 1141N2280KSisco Avery W · Amarillo, TXBuilt 1978 · S/N 1566N22849Registered aircraftBuilt 1980 · S/N 1N2288KJames Kevin L · Hayden, ALBuilt 1982 · S/N 9N228TWb Aviation LLC · Saint Jo, TXBuilt 1953 · S/N 18-2342N229DKKoerkenmeier James J · Carlyle, ILBuilt 1979 · S/N 15283544N229TGagnon Matthew I · Fairbanks, AKS/N 18-2343N22KVClack Justin · Oak Grove, LABuilt 1978 · S/N 38-79A0046N22LKBernier James · Granbury, TXBuilt 1989 · S/N 1N22WAQuillan Patrick M · Wyoming, MIBuilt 1971 · S/N AA1A-0282N2300Eaa Aviation Foundation · Oshkosh, WIBuilt 1969 · S/N 500N2305NJcfl LLC · Houma, LABuilt 1947 · S/N 12545N230ABAllen John L · Big Sandy, TNBuilt 1995 · S/N 607N230SVSwailes Craig · Taylor, MIBuilt 1979 · S/N 152-83257N230THague Creek Aviation LLC · Phoenix, AZS/N 18-2344N2313NClark Randy L · Burlington, COBuilt 1979 · S/N 38-79A0781N23140Flora James L · Mitchell, INBuilt 1981 · S/N 38-81A0119N2314MMullins Esten R · El Paso, TXBuilt 1946 · S/N 12-1478N2315MBalfany Michael D · Kingston, NVBuilt 1946 · S/N 12-1479N2315VAnywhere Atp LLC · Mount Juliet, TNS/N 38-82A0085N2316MRed Tail Aviation LLC · Pueblo, COBuilt 1946 · S/N 12-1480N23173Garza David J · Mcallen, TXBuilt 1981 · S/N 38-81A0123N2317BCylinder Optics Inc · Garden City, MOS/N 38-79A0007N2318MRentz Travis Kyle · Palmer, AKBuilt 1946 · S/N 12-1385
Back to AD 80-25-02 R2