OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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-07-R1')
    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-07-R1')
  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.

N58135Petticrew Travis R · Mckinney, TXBuilt 1986 · S/N 24-1567N5813FGalligan Derek · Portland, ORBuilt 1985 · S/N 24-1563N5813QWalmsley Stephen R Jr · Menifee, CABuilt 1965 · S/N 772N5813UStackhouse Thomas G · Bethlehem, PAS/N 24-1649N58143Sustich Steven R · Odessa, TXBuilt 1985 · S/N 24-1573N58144Low Daniel A · Los Angeles, CABuilt 1985 · S/N 24-1574N58148Wilkerson James · Howell, MIS/N 24-3000N5814QKlapper Robert D · San Jose, CABuilt 1985 · S/N 24-1570N5814TMulligan Shawn Patrick · Santa Rosa, CABuilt 1985 · S/N 24-1571N5814YSarshad Todd · San Pablo, CABuilt 1985 · S/N 24-1572N58153Marsan Steve R · Sisters, ORS/N 24-1580N58156Kim Seuk · Springfield, VABuilt 1986 · S/N 24-1582N58158Austin Mooney Flyers LLC · Austin, TXBuilt 1984 · S/N 24-1509N58159Mcclure Jeffrey S · Loomis, CAS/N 24-1650N5815CFrogmore Flyers LLC · St Helena Is, SCBuilt 1985 · S/N 24-1576N5815SClear Aire LLC · Las Vegas, NVBuilt 1986 · S/N 24-1577N5815XMorozov Nikolai · Tucson, AZBuilt 1986 · S/N 24-1578N58162Link Stanley C · Theodosia, MOS/N 24-1587N58166Harrie Michael Raymond · Marsing, IDS/N 24-1588N5816QHigh Flying Vision LLC · Clarksdale, MSBuilt 1965 · S/N 3117N5816TCrossroad Productions LLC · Covington, LABuilt 1985 · S/N 24-1569N5816WQin David · La Verne, CAS/N 24-1586N5817AMarceau Michelle · Spofford, NHS/N 24-1656N5817QMcinnis Services LLC · O Brien, FLS/N 774N5817TSnow Robert I · New Caney, TXBuilt 1988 · S/N 24-1654N581DMTichy Thomas H · Albuquerque, NMBuilt 2002 · S/N 894-2002N581ESQuinby Alan D · Woodward, OKBuilt 1978 · S/N 17271811N581SBHudson Harold Daniel · Williamsburg, VABuilt 1965 · S/N 3115N5820QSmith Douglas C · Lewisville, TXBuilt 1965 · S/N 3119N5822QKnudsen Ernst W · Ennis, TXBuilt 1965 · S/N 3120N5823QRegistered aircraftBuilt 1965 · S/N 777N5824QTss-Glass Machinery Sales Inc · Fort Worth, TXS/N 3121N5825QHobgood Joel A · Sharpsburg, GABuilt 1965 · S/N 778N5826QN5826q LLC · Sheridan, WYBuilt 1965 · S/N 3122N5827QPromises LLC · Pompano Beach, FLBuilt 1965 · S/N 859N5828QGreater Cincinnati Aero Club LLC · Alexandria, KYBuilt 1965 · S/N 3123N5829QHenery L Bodmer Inc · Kenmare, NDBuilt 1965 · S/N 780N5831QCueva Arturo A · Los Angeles, CABuilt 1965 · S/N 781N5832JAerial Advertising Services · Livermore, CAS/N 17273842N5832QHli Aviation LLC · Red Banks, MSBuilt 1965 · S/N 3125N5833JAlbatross Air Inc · Beaver, WVBuilt 1980 · S/N 17273843N5833QDyer Albert L · New Smyrna Beach, FLBuilt 1965 · S/N 782N5834QGill Harold P · Bolton, MABuilt 1965 · S/N 3126N5839QSnodgrass Michelle B · Sierra Vista, AZBuilt 1965 · S/N 785N5841QGuziec Philip R · Riverwoods, ILS/N 786N5842QBradford Michael · San Jose, CABuilt 1965 · S/N 3130N5843QKeane Christopher · Salem, NHBuilt 1965 · S/N 787N5846QGardner Perry F · East Canaan, CTBuilt 1965 · S/N 3132N5848QValenti Edgar M · Gig Harbor, WABuilt 1965 · S/N 3133N584CMBurns Timothy R · Eighty Four, PABuilt 1978 · S/N 24-0544
Back to AD 80-25-07 R1