OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,364

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.

N122HSafeline Aviation LLC · Apache Junction, AZBuilt 1999 · S/N 1274-99N122JDGrasshopper Aviation LLC · Hockley, TXBuilt 2000 · S/N 1301-2000N122MJHyper Flight Inc · Seattle, WABuilt 1977 · S/N 17270043N122MWWalker Kyle E · Lawrence, KSBuilt 1979 · S/N R18201276N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842N122WRRangers Flying Club Inc · Eden Prairie, MNBuilt 1975 · S/N 177RG0744N1230MGoos Farms Inc · Silver City, IABuilt 2002 · S/N 1327-2002N1230SSpecialized Aero Works LLC · Bend, ORBuilt 2005 · S/N 1011-2005N1230XMarquez Christopher · Gaithersburg, MDBuilt 1963 · S/N 104N1231WMusa Adam · Princeton, NJBuilt 1967 · S/N 670099N1232UOrganization Of Black Aerospace Professionals Inc · Westchester, ILS/N 17266928N1232WMilam David N · Hannibal, MOBuilt 1967 · S/N 670088N12330Liller Kenneth F · New Port Richey, FLBuilt 1973 · S/N 17261932N12331N Conti Inc · Boyertown, PABuilt 1973 · S/N 17261933N12335Truscott Jon M · Sunfield, MIBuilt 1973 · S/N 17261935N12336Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 17261936N12339Howard Ronald W · Okeechobee, FLBuilt 1973 · S/N 17261937N1233UMagnum Air LLC · Camp Hill, PABuilt 1976 · S/N 17266929N12341Merl Robert B · Los Alamos, NMBuilt 1973 · S/N 17261938N12342Simpson Elden G · Prineville, ORBuilt 1973 · S/N 17261939N12343Albany Aviation Ny LLC · Nassau, NYBuilt 1973 · S/N 17261940N12346Baidenmann Maralin Frances · Bend, ORBuilt 1973 · S/N 17261941N1234GBs1 LLC · Lafayette, INBuilt 1987 · S/N 24-1614N1234KLatiolais Travis · Breaux Bridge, LABuilt 1966 · S/N 995N1235XRudy Alan J · Phoenix, NYBuilt 1963 · S/N 108N12360Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261947N12365Singh Jaganpreet · Bakersfield, CABuilt 1973 · S/N 17261950N12366Zimmerman Michael P · Verona, WIBuilt 1973 · S/N 17261951N1236UKosmoski Matthew J · Katy, TXBuilt 1976 · S/N 17266931N1236XFull Mooney LLC · Camden, DES/N 109N12375Bauer Kathleen S · Harrison City, PABuilt 1973 · S/N 17261954N12376Lockwood Connor A · Anchorage, AKS/N 17261955N12379Kolar Ken DBA · Brazoria, TXBuilt 1973 · S/N 17261957N1237UStaehling Jonathan J · Woodstock, ILBuilt 1976 · S/N 17266932N12382Blue Sky Pilots Inc DBA · Salem, ORBuilt 1973 · S/N 17261958N12387Bayramoglu Ulug S · Carrollton, TXS/N 17261961N12388Autry Lonnie E · San Jose, CABuilt 1973 · S/N 17261962N1238XAljo Aircraft Corp · Arroyo Grande, CAS/N 111N12390Lowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1973 · S/N 17261963N12391Lowe Ralph D · Magnolia Springs, ALBuilt 1973 · S/N 17261964N12394Hayek David · Bryan, TXBuilt 1973 · S/N 17261967N12395Consolidated Aviation Services LLC · Seymour, TNBuilt 1973 · S/N 17261968N12398Cianfichi Jamie J · Moscow, PABuilt 1973 · S/N 17261971N1239XAircraft Ownership Solutions LLC · Kokomo, INS/N 112N123BYRegistered aircraftBuilt 2003 · S/N 915-2003N123CBC C Flying Club · Seattle, WABuilt 1973 · S/N 17262283N123CCColumbia Mooney LLC · Columbia, MOBuilt 1977 · S/N 24-0138N123CLPcs Air LLC · Middletown, PABuilt 1972 · S/N 17261064N123DAVanderpool Tyler · Edinburg, TXS/N 798-71N123DSDenton Farms LLC · Williamsburg, MIBuilt 1975 · S/N 17702373
Back to AD 80-25-07 R1