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.

N5702ZVanhouten Christian J · Tunkhannock, PABuilt 1962 · S/N 22-9540N5703HLauda Thomas J · Des Moines, IABuilt 1949 · S/N 16-314N5704HMcbride Robert W Jr · Cedar Park, TXBuilt 1949 · S/N 16-315N5704ZSmalbergher Dorin · Soldiers Grove, WIBuilt 1963 · S/N 22-9542N5705HHangar 13 LLC · Winchester, VAS/N 16-316N5705LKing William C · Huntington Beach, CABuilt 1969 · S/N AA1-0105N5706HWhitlock Paul H · Kent, WAS/N 16-317N5707HMooney Timothy · Hedgesville, WVBuilt 1949 · S/N 16-318N5708HGodec David E · Waunakee, WIBuilt 1949 · S/N 16-319N5708ZSantee Steven J · Ellendale, MNBuilt 1962 · S/N 22-9547N5709HSmith Zac A · Mill Valley, CAS/N 16-320N5709ZBettilyon Walter S · Shady Shores, TXBuilt 1963 · S/N 22-9548N5710ZSpangler David G · New Richmond, WIBuilt 1962 · S/N 22-9549N5712ZVollmerhausen Otto J · Bethpage, NYBuilt 1963 · S/N 22-9551N5714HThomsen Michael · Pleasanton, CAS/N 16-326N5715HReuhl Kenneth R · Piscataway, NJBuilt 1949 · S/N 16-327N5715ZProper Theron · Arlington, AZBuilt 1963 · S/N 22-9554N5716HLeaders Flying Service LLC · Clear Lake, MNBuilt 1949 · S/N 16-328N5717LChristian George D · Kingwood, TXBuilt 1969 · S/N AA1-0117N5717ZJohnston Charles W C Jr · Newfield, NJBuilt 1963 · S/N 22-9556N5718LMullins John D · Harriman, TNS/N AA1-0118N5719HPetersen Danny · Caddo, OKBuilt 1949 · S/N 16-331N5719LGodoy Air LLC · Venice, FLS/N AA1-0119N571MMMoment Stv L · Urbana, ILBuilt 2008 · S/N 06118N5720LKh Aircraft LLC · Denton, MTBuilt 1969 · S/N AA1-0120N5720ZIrvine Hollis E Jr · Greenwich, NJBuilt 1963 · S/N 22-9559N5721LBerggren Ryan J · Newton, NJBuilt 1969 · S/N AA1-0121N5723HValiair Lc Trustee · Casper, WYBuilt 1949 · S/N 16-334N5723LPearlman Fredric M · Southfield, MIS/N AA1-0123N5724HPhillips Thomas D · San Antonio, TXBuilt 1949 · S/N 16-336N5724ZKpa LLC · Kalamazoo, MIS/N 22-9563N5725HPeterson Gordon L · De Pere, WIBuilt 1949 · S/N 16-337N5725ZHolt Gary E · Sandusky, OHBuilt 1963 · S/N 22-9564N5728HBell Jeff J · Merritt Island, FLFirst renewal noticeS/N 16-340N5729HAbbott Sean N · South Paris, MEBuilt 1949 · S/N 16-341N5730HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1949 · S/N 16-342N5731ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1963 · S/N 22-9570N5732HWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1949 · S/N 16-346N5735ZCrouch Michael G · Brazoria, TXBuilt 1963 · S/N 22-9574N5736HEdwards Stephen L Trustee · Wasilla, AKBuilt 1949 · S/N 16-348N5736ZMiller Andy D · Marana, AZBuilt 1963 · S/N 22-9575N57383Dalley Robert C · Waldron, INBuilt 1973 · S/N 936-73N5738HWalker Scott E · Largo, FLBuilt 1949 · S/N 16-350N5738LRosche Henry III · Loveland, OHS/N AA1-0138N5739HRegistered aircraftBuilt 1949 · S/N 16-351N5739LMcgll Phil · Huntsville, ALBuilt 1969 · S/N AA1-0139N57404Cp Aviation Inc · Santa Paula, CABuilt 1973 · S/N 940-73N5740HPritchett Michael L · Benton, ARS/N 16-352N5740ZLashley Chad P · Wentzville, MOBuilt 1963 · S/N 22-9579N57410Eddy William Crawford III · Sugar Hill, GABuilt 1973 · S/N 941-73
Back to AD 80-25-02 R2