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.

N5651HCramer Nicholas R · Lexington, OHS/N 16-262N5652ZClifford Karl N · Lubbock, TXBuilt 1962 · S/N 22-9475N5653LUlpiano Amy · Carolina, PRBuilt 1969 · S/N AA1-0053N5655HRansdell Elise A · Springfield, ILBuilt 1947 · S/N 16-266N5655ZTroth Gary D · Mound City, KSBuilt 1962 · S/N 22-9478N5657LSkyray LLC · Sugar Land, TXBuilt 1969 · S/N AA1-0057N5658LBores Scott J · Huron, OHS/N AA1-0058N565WWard Ann Marie · Seattle, WABuilt 1978 · S/N 15281812N5661HSullivan Thomas S · Quinnesec, MIBuilt 1949 · S/N 16-272N5663LChino Aviation Inc · Chino, CAS/N AA1-0063N5664HPierce Stephan L · Graham, TXBuilt 1949 · S/N 16-275N5665ZPerez John-Henry · Locust Grove, GABuilt 1962 · S/N 22-9488N5666ZWheeler James R · Falling Waters, WVBuilt 1962 · S/N 22-9489N5667HLeader Russell J · Glasgow, MTS/N 16-278N5669HUsaviation.Com LLC · Moorestown, NJBuilt 1949 · S/N 16-280N5669LGallien Justin A · Livermore, CABuilt 1969 · S/N AA1-0069N566RCJacques Adam P · Weirsdale, FLBuilt 2015 · S/N 75-8433N5670LCranford Julian Edward Jr · Lexington, NCFirst renewal noticeBuilt 1969 · S/N AA1-0070N5671LJudge Russell M · Newton, NJBuilt 1969 · S/N AA1-0071N5672HPound Haley E · Temple, TXBuilt 1949 · S/N 16-283N5673HMalone William Z · Mount Nebo, WVS/N 16-284N5675HGreen William C · Mancelona, MIBuilt 1949 · S/N 16-290N5676HDart Gregory G · Mayville, NYBuilt 1949 · S/N 16-286N5676ZHenderson Joseph C · Midlothian, VABuilt 1963 · S/N 22-9502N5677LDuncan Lincoln · Dix, ILBuilt 1969 · S/N AA1-0077N567KSKing Sky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15282634N5680HEpting Robert L · Chapel Hill, NCBuilt 1949 · S/N 16-292N5680LStackpole Thomas M · Temecula, CABuilt 1969 · S/N AA1-0080N5681ZCalvert Scott R · Pequannock, NJBuilt 1962 · S/N 22-9508N5682LLahlum Steven R · Warroad, MNBuilt 1969 · S/N AA1-0082N5683ZPalmenteri Louis · Rhome, TXBuilt 1962 · S/N 22-9512N5684ZMuehlberg Stephen E · Newcastle, OKBuilt 1962 · S/N 22-9514N5685LFritz Frank M · Milwaukee, WIBuilt 1969 · S/N AA1-0085N5686LBresson Kyle M · Roxbury, CTBuilt 1969 · S/N AA1-0086N5687LDedominici Kenneth · Vero Beach, FLS/N AA1-0087N5688HSheradin Roland R · Cape Coral, FLBuilt 1949 · S/N 16-300N5688LDolan John C · Sequim, WAS/N AA1-0088N5689HChristie Ian A H · Limon, COS/N 16-301N5689ZNichols Troy G · Clinton, ARS/N 22-9522N568MCow Bell LLC · Sterling, AKBuilt 1946 · S/N 12-952N5690HBackus-Flint Judith A · Blanchard, MIBuilt 1949 · S/N 16-302N5692HHarma Michael J · Ironwood, MIBuilt 1949 · S/N 16-303N5693HDorsay Edward R · Memphis, TNBuilt 1949 · S/N 16-304N5693ZRustin Cody W · Reynolds, GABuilt 1962 · S/N 22-9527N5696HVaughan William R IV · Benton, MSBuilt 1949 · S/N 16-307N5697ZLink James L · Raleigh, NCS/N 22-9532N5699HHalmans John D · Baker, MTS/N 16-310N569NEMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1978 · S/N 15282580N56JFWadsworth Chad · Lake Havasu City, AZBuilt 1997 · S/N 53N5702HMorrissey Philip A · Templeton, MABuilt 1949 · S/N 16-313
Back to AD 80-25-02 R2