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.

N4277MDykema Richard Kenneth · Soldotna, AKS/N 12-3205N4278HWrigley David C · Anchorage, AKBuilt 1948 · S/N 14-83N4278LIron Compass Aviation LLC · Gallatin, TNBuilt 1978 · S/N 15281218N4282MGlave William C · Deltaville, VABuilt 1947 · S/N 12-3210N4283HRubbert Jan D · Upham, NDBuilt 1948 · S/N 14-88N4283MDavis Roger · Dover, PABuilt 1947 · S/N 12-3211N4288MMy Holdings Inc · Anchorage, AKBuilt 1947 · S/N 12-3218N428HCNott Terry · Overland Park, KSBuilt 1979 · S/N 15283916N4290EAnderson Todd R · Bremerton, WABuilt 1978 · S/N 38-78A0532N4294MBreiner Joyce K · Poolesville, MDBuilt 1947 · S/N 12-3225N4296MFowler Garry E · Post Falls, IDS/N 12-3228N4298EParish Matthew G · Drummonds, TNBuilt 1978 · S/N 38-78A0535N429TYancey Michael E · Brighton, TNBuilt 1981 · S/N 688N42LEMason County Aero Club · Ludington, MIBuilt 1991 · S/N 1024N4300DNugent Michael W · New Caney, TXBuilt 1991 · S/N MB1-1990-91N4303MLight John W · Anchorage, AKBuilt 1947 · S/N 12-3235N4305MBierlein Bruce M · Reese, MIBuilt 1947 · S/N 12-3237N430MDMattes Michael A · Churubusco, INBuilt 2011 · S/N MB-1N4315MArntson Le Delle E · Eagle River, AKBuilt 1947 · S/N 12-3248N43162Eaglex Aviation LLC · Esko, MNBuilt 1998 · S/N S 9510-0151N4319EAcevedo Adriel · San Antonio, TXBuilt 1978 · S/N 38-78A0548N4322MVeal Jeffrey S · Sterling, AKS/N 12-3257N4323YRyer Michael · Salem, ORBuilt 1996 · S/N 011998N4324MMulligan William O · Valentine, NEBuilt 1947 · S/N 12-3259N4327EPegasus Enterprises LLC · Overton, NVBuilt 1978 · S/N 38-78A0553N4328MMisch Gordon L · Toledo, WABuilt 1947 · S/N 12-3262N432BQBrowning Aviation LLC · Deputy, INS/N Q-002N4330EDooley Jon S · Greensburg, INS/N 38-78A0555N4330MCarson Brian P · Battle Creek, MIBuilt 1947 · S/N 12-3269N4333MHodges June M · Wasilla, AKBuilt 1947 · S/N 12-3267N43373Hunter Robert M · Rawlins, WYBuilt 2006 · S/N 6-3803N4339MLazor Ronald E · Middlefield, CTBuilt 1947 · S/N 12-3275N4340MMiller William M · Brenham, TXBuilt 1947 · S/N 12-3276N4341PToribio LLC · San Antonio, TXS/N PJ0222366N4342EMoon Jonathan Edward · Butler, PABuilt 1978 · S/N 38-78A0564N4342MStout Lloyd J · Belmont, CABuilt 1947 · S/N 12-3280N4345MTice Robert M · Millinocket, MEBuilt 1947 · S/N 12-3283N4347ECarver Lloyd · Snellville, GABuilt 1978 · S/N 38-78A0570N4349MRupiper Nicholas J · Ankeny, IABuilt 1949 · S/N 12-3287N434ABMondkar Avinash M · Payson, AZBuilt 1940 · S/N 5-373N4350EUrgiles Carbaca Andres A · Lantana, FLBuilt 1978 · S/N 38-78A0571N4356EGarcia Alfonso · Lovington, NMFirst renewal noticeBuilt 1978 · S/N 38-78A0573N4356MWalton Alfred V Jr · Shattuck, OKBuilt 1947 · S/N 12-3294N4364MChildress Michael C · Akron, OHBuilt 1947 · S/N 12-3302N4365MMartin Nathaniel W · Wasilla, AKBuilt 1947 · S/N 12-3303N4366MCline Robert A · Clarkston, WABuilt 1947 · S/N 12-3312N4370MDunker Arden J · Boise, IDBuilt 1947 · S/N 12-3306N4372MRegistration Pending · Tulsa, OKRegistration pendingBuilt 1947 · S/N 12-3308N4375MKrapels Keith A · Huntsville, ALBuilt 1947 · S/N 12-3319N4377MBeach Banners Inc · Jacksonville, FLBuilt 1947 · S/N 12-3311
Back to AD 80-25-02 R2