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.

N5962QNewell Robert T · Angel Fire, NMBuilt 1965 · S/N 842N5963QKatz Matthew · Los Angeles, CABuilt 1965 · S/N 3199N5964QLin Andrew Hsia · Huntingtown, MDBuilt 1965 · S/N 3200N5966QFarwell Jason E · Lansing, KSBuilt 1965 · S/N 844N5968QChess House LLC · Canton, SDS/N 3202N5969QAbdelsalam Moustafa Gamal · Buena Park, CABuilt 1965 · S/N 845N596JRWilliams David J · San Francisco, CAS/N 1359-96N5970QYeager Robert Allen · Oregon City, ORBuilt 1965 · S/N 3203N5973QFarias Gerardo M · Panama City Beach, FLS/N 847N5974QTaylor Timothy T · Quitman, ARFirst renewal noticeBuilt 1965 · S/N 3205N5976EFunkhouser Dennis E · Fredericksburg, VABuilt 1978 · S/N 17271978N5976QEscobar Timothy · San Antonio, TXBuilt 1965 · S/N 848N5978QBauer Jared R · Sugar City, COBuilt 1965 · S/N 3208N5979QBlount Aviation LLC · Metairie, LABuilt 1965 · S/N 849N597CAWest Wind Farm Inc · Camarillo, CABuilt 1979 · S/N 24-0784N597CMAerospace Trust Managment LLC Owner Trustee · Wilmington, DEBuilt 2013 · S/N 1130-2013N597DMBrandon Air LLC · Valley Stream, NYBuilt 1976 · S/N 17268041N597MBBrandon Air LLC · Valley Stream, NYBuilt 1983 · S/N 24-1391N597NDNicholas James Esch · Cedar Rapids, IABuilt 1967 · S/N 670041N597TTTerrell David R · Smithville, TNBuilt 1969 · S/N 17701403N5983JIlarraza Gilberto C · Sabana Hoyos, PRS/N 17273848N5983MPhilipp Michael W · Thief River Falls, MNS/N 17260945N5984QSlow Walkin Barnstormers LLC · Frostproof, FLBuilt 1965 · S/N 3211N5985QInderkummen Jean Pierre · Gulfport, MSFirst renewal noticeBuilt 1965 · S/N 3212N5986QFord Christopher D · Brunswick, GAS/N 852N5987GSchwend Brian · Forsyth, MTBuilt 1973 · S/N 18801166N5987QHardesty William A · San Diego, CABuilt 1965 · S/N 853N5988QLynn Seth D · Killeen, TXS/N 3213N5989QPressley Brent DBA · Morristown, TNS/N 3214N598BGSamuel James · College Station, TXBuilt 1995 · S/N 24-3371N5990EManeuvering Speed Inc · Wilmington, DEBuilt 1978 · S/N 17271980N5990QShowman Benjamin J · Danville, ALBuilt 1965 · S/N 854N5991QBain Douglas D · Vega, TXBuilt 1966 · S/N 3215N5992QFriday Ryan M · Elizabeth, PABuilt 1965 · S/N 3216N5993ETss Flying Club Inc · Bethesda, MDBuilt 1978 · S/N 17271981N5993QDeley Mike · Menifee, CABuilt 1965 · S/N 855N5995QFangmeier Benjamin A · Strasburg, COBuilt 1965 · S/N 3217N599CMMscm Partners LLC · Fairfield, TXS/N 17257970N599DKEngler Jerry J · Kerrville, TXBuilt 1999 · S/N 419-99N59ACWatson David A · San Jose, CABuilt 1995 · S/N 747-95N59BJWalser Air LLC · Warwick, RIBuilt 1965 · S/N 2968N59LAAlphin Lewis Jackson · Mount Olive, NCBuilt 1999 · S/N 430-99N59MSSojka Michael J · Bainbridge, INBuilt 1994 · S/N 735-94N59PGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260347N59PHSeider Jason · Dallas, TXBuilt 1968 · S/N 680116N59VLKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259905N59WDHorner Michael W · Manakin Sabot, VABuilt 2007 · S/N 1423-2007N59WLHerrmann Mark D · Dillingham, AKS/N 269-70N5AKHackler Tara Cole · Bend, ORBuilt 1977 · S/N 17268768N5BJLinrud Michael A · Velva, NDBuilt 1969 · S/N 187
Back to AD 80-25-07 R1