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.

N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118N9315ESmith Mark S · Cornville, AZS/N 17272221N9315MTwo Dog Aviation LLC · Bismarck, NDBuilt 1966 · S/N 1248N9315RChase Steven J · Aubrey, TXBuilt 1978 · S/N R18200686N9315VGroff Joseph J · Colfax, CABuilt 1969 · S/N 690092N93166Kelly William W · Springfield, ORBuilt 1981 · S/N 15285428N9316MSale Reported · Kalispell, MTSale reportedBuilt 1966 · S/N 670001N9316VBorghi Robert J · Leonia, NJBuilt 1969 · S/N 690071N9317RLloyd William E Jr · Clinton, TNBuilt 1979 · S/N R18200687N9317VSpaghetti Aviation LLC · Derby, KSBuilt 1969 · S/N 690093N9318BAnderson Daniel R · Venus, TXS/N 172RG0790N9318TGuerra Eduardo · Polk City, FLS/N 38-78A0028N93196Registration Pending · Lafayette, LARegistration pendingBuilt 1981 · S/N 15285439N9319HHoffman Stanley L Jr · Bethel, AKBuilt 1975 · S/N 17266084N9319MCulberson Donald L · Bedford, TXBuilt 1966 · S/N 1251N931MSColeman Aviation LLC · Livingston, TNBuilt 1968 · S/N 17257349N931SCActiveair LLC · Erie, PABuilt 1978 · S/N 38-79A0391N9320DDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 172RG1119N9320HPlane Tail LLC · Bethany, CTBuilt 1975 · S/N 17266085N9320MMoreau Donald G · Dayton, TXBuilt 1966 · S/N 1252N9320RHaskell Flyers LLC · Sublette, KSBuilt 1978 · S/N R18200689N93214Sundance Air Services Inc · Alameda, CABuilt 1981 · S/N 15285444N9321EMertinez Matos Daniel Enrique · Fajardo, PRS/N 17272225N9322MQuebedeaux Rentals LLC · Deridder, LAS/N 1254N93239Minuteman Aviation Inc · Missoula, MTBuilt 1981 · S/N 15285447N9323ESchock Richard F II · Peoria, ILBuilt 1979 · S/N 17272226N9323MMichael Siewert · Columbus, OHS/N 1255N9324MMcdonald Glenn · Uvalde, TXS/N 1256N9324VPontoni Development Corp · Athens, MIS/N 690073N93251Flaherty Edward T · Scotia, NYBuilt 1981 · S/N 15285448N9325VJaa Holdings LLC · Springfield, ILS/N 690096N93263Xin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 15285451N93264Wolfe Michael S · Norco, CABuilt 1981 · S/N 15285452N9326DAll Seasons Aviation LLC · Laredo, TXBuilt 1982 · S/N 172RG1122N9326EWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 17272228N9326MWoods Brian S · Longview, TXBuilt 1966 · S/N 1258N9326VSprang Bob E · Smithville, OHBuilt 1969 · S/N 700002N93271Pauma Holdings LLC · Colorado Springs, COBuilt 1981 · S/N 15285454N9327MChristensen Seth T · Hurricane, UTBuilt 1966 · S/N 1259N9327TFlener Stephen J · Sterling, OHBuilt 1978 · S/N 38-78A0036N93281Bishop Mike · Rifle, COBuilt 1981 · S/N 15285456N9328MBeauchamp Michael · Las Vegas, NVBuilt 1966 · S/N 1260N9329MSreffler Christine · Ballwin, MOBuilt 1966 · S/N 1261N932AZN932az LLC · Miami, FLBuilt 1986 · S/N 17276586N932JMTacos On Wheels LLC · El Paso, TXBuilt 1981 · S/N 18267894N93304Jodkin Jason · Confluence, PABuilt 1981 · S/N 15285464N9330VWest Daryl DBA · Kirkland, WABuilt 1969 · S/N 700003N9331VMartin Edward J · Poplar Grove, ILBuilt 1969 · S/N 700002N9332MKasakoff Lloyd · Diamond Bar, CAS/N 1264N93339Mcgee David · Monroe, LABuilt 1981 · S/N 15285470
Back to AD 80-25-07 R1