OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,368

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.

N9526MRegistered aircraftBuilt 1966 · S/N 670103N9528YHunt William R · Tucson, AZBuilt 1981 · S/N 21064538N9529MWilson Judy · Stamps, ARBuilt 1966 · S/N 670106N952BPhillips Chad · Teague, TXBuilt 2006 · S/N 1408-2006N952CBCentral Business Jets Inc · Burnsville, MNBuilt 1979 · S/N 21063729N952EROliver Lawrence G · Lewiston, MEBuilt 2011 · S/N 1109-2011N952MKhan Mohsin H · Lodi, CABuilt 1966 · S/N 3364N952RHKilo Alpha Flights · Long Beach, CABuilt 1981 · S/N 24-1177N952WAMcenery William J · East Haddam, CTBuilt 1973 · S/N 394-73N9530BSierra Alpha Aeronautical LLC · San Antonio, TXBuilt 1981 · S/N 172RG0858N9531BLash Trucking LLC · Goleta, CABuilt 1979 · S/N 21063175N9531MWright Bradley S · Quitaque, TXS/N 670108N9531SUpland Amy L · Miami Springs, FLBuilt 1966 · S/N 349N9533MHattensty Robert Wade · Burleson, TXBuilt 1966 · S/N 670110N9533YN9533y Corp Trustee · Wilmington, DEBuilt 1981 · S/N 21064539N9534HBotezatu Florin · Gig Harbor, WABuilt 1975 · S/N 17266208N9534SBall Ronald C · Colby, KSBuilt 1965 · S/N 297N9535HNorthwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17266209N9535MGillman Charles J · Houston, TXBuilt 1966 · S/N 670112N9535YSpectra Q LLC · Las Vegas, NVBuilt 1981 · S/N 21064540N9536HSampson Kelly J · Canby, ORS/N 17266210N9536SExpress Aviation LLC · Philadelphia, MSBuilt 1966 · S/N 94N95374Board Of Trustees DBA · Murphysboro, ILBuilt 1984 · S/N 15285879N9537LPence Jeffrey S · Edinburg, VABuilt 1986 · S/N 17276571N9537MWatts Brett M · Prescott, AZBuilt 1966 · S/N 670114N9537SHowell Alice R · Bainbridge, GABuilt 1965 · S/N 23N9538HK & L Air Inc · Brazil, INBuilt 1975 · S/N 17266212N9538SClark William · Easton, MOBuilt 1965 · S/N 304N95391Training Planes LLC · Tampa, FLBuilt 1984 · S/N 15285881N9539BThree Rivers Limousine Service Inc · Pittsburgh, PABuilt 1981 · S/N 172RG0865N9539MPfaltzgraff George E A · Solon Springs, WIBuilt 1966 · S/N 670116N9539SFox Norman A · Maryville, TNBuilt 1965 · S/N 305N953MAGutierrez Francisco J · Laredo, TXS/N 3372N953SASunrise Aviation Inc · Ormond Beach, FLBuilt 1980 · S/N 15283908N953SMBogen Alfred T · Brandon, MSBuilt 1980 · S/N 172RG0772N95404Delta State University · Cleveland, MSBuilt 1984 · S/N 15285887N9540BFly8ma LLC · Big Lake, AKBuilt 1981 · S/N 172RG0866N9540GSchwend Brian · Forsyth, MTBuilt 1974 · S/N 18801520N9540LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276574N9540MBostrom Zachary J · Ballwin, MOBuilt 1966 · S/N 670117N9540SNeufeld Maria · Seminole, TXBuilt 1965 · S/N 258N9541GAllen Charles Mark · Puryear, TNBuilt 1974 · S/N 18801521N95429Suburban Air Corp · Castro Valley, CABuilt 1984 · S/N 15285892N9542BSoileau Kenneth B · Lancaster, SCBuilt 1981 · S/N 172RG0867N9542HAbusham Hamed M · Upland, CABuilt 1975 · S/N 17266215N95431Kent State University · Stow, OHBuilt 1984 · S/N 15285893N95435Bird Acquisition LLC · Phoenix, AZFirst renewal noticeS/N 15285895N9543HGonzalez-Rio Jesus A · Big Pine Key, FLBuilt 1975 · S/N 17266216N9543MReedy Coleman · Cool, CAS/N 670120N9543STherkelsen Robert D · Burlington, WABuilt 1965 · S/N 271
Back to AD 80-25-07 R1