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.

N205CBBusse Christopher K · Leo, INS/N 24-0983N205CCHinn Terry A · Hot Springs, SDS/N 24-3044N205CSFillwock Bryan T · Saint Joseph, MIBuilt 1977 · S/N 24-0223N205DAero America Holdings LLC · Indianola, IAS/N 24-3005N205DCPocohantas Holdings LLC · Annapolis, MDBuilt 1986 · S/N 24-3004N205GIntegrity Aero LLC · Boerne, TXBuilt 1987 · S/N 24-3038N205HHayes Manufacturing · Parsons, TNBuilt 1986 · S/N 24-3006N205HBMattes Michael Alan · Sherman Oaks, CABuilt 1977 · S/N 24-0288N205JBmr Aviation LLC · Wilmington, DEBuilt 1986 · S/N 24-3002N205JJUpchurch Howard L · Pikeville, TNS/N 24-3053N205JSHollenberg Randall W · Houston, TXS/N 24-3001N205KDBats Aero LLC · Missoula, MTBuilt 1986 · S/N 24-3017N205KKBrignac Valmon Anthony III · Raleigh, NCBuilt 1987 · S/N 24-3054N205LLStemple Jasper Forest · Kalispell, MTS/N 24-3055N205MAWarbird Adventures Inc · Ocoee, FLBuilt 1979 · S/N 530-79N205MESf Imports LLC · Bluffdale, UTBuilt 1990 · S/N 24-3161N205MGGanter Berthold H · Woodside, CABuilt 1987 · S/N 24-3025N205MHIsmail Ahmad · Richmond, VAS/N 24-3026N205MKCloudskipper Inc · Salisbury, MDBuilt 1987 · S/N 24-3029N205MNCubbage Mark J · Tucson, AZS/N 24-3019N205MPSadler Ryan T · Alameda, CABuilt 1987 · S/N 24-3032N205NHuff Thomas W · West Melbourne, FLBuilt 1987 · S/N 24-3030N205PLQuinones Luis I · Gaithersburg, MDBuilt 1987 · S/N 24-3020N205PPBelai E Enterprise LLC · Burleson, TXFirst renewal noticeS/N 24-3061N205QQSundhagen Construction Inc · Saint Ignatius, MTS/N 24-3069N205RGKeating Kevin C · Asheville, NCBuilt 1988 · S/N 243078N205RJBrickey Thomas J · Loveland, OHBuilt 1979 · S/N 24-0774N205RLAlcott Thomas J · Jacksonville, ILBuilt 1987 · S/N 24-3022N205RSGansta Of Love LLC · Moorpark, CABuilt 1979 · S/N 24-0797N205RWGarratt Tyler Trustee · Carlsbad, CAS/N 24-3052N205SJudson Alexander · Hermitage, TNS/N 24-3014N205SERecreation Activity Club Inc · Bloomfield Hills, MIS/N 24-3051N205SSAir Turbo LLC · White, GAS/N 24-3060N205TGLe Garrec Jean-Dominique M · Pittsburgh, PABuilt 1987 · S/N 24-3041N205UGoro Sky Aircraft LLC · Lino Lakes, MNS/N 24-3036N205UUTailwind Blue LLC · Lakewood, COBuilt 1988 · S/N 24-3067N205VVAawca Wings LLC · Augusta, MIBuilt 1988 · S/N 24-3068N20600Occupational Health Services · Green Bay, WIBuilt 1973 · S/N 17261432N20601Gilfert James M · Sunbury, PABuilt 1973 · S/N 17261433N20604Leffler Paul E · Churubusco, INBuilt 1973 · S/N 17261434N20606Vander Roest Raymond · Scotts, MIBuilt 1973 · S/N 17261436N2060EBlackstone Aircraft LLC · Hartselle, ALS/N 17271138N2060QAlvarez Manuel B · Linden, MIBuilt 1973 · S/N 177RG0460N20612Bentley Drive LLC · Anchorage, AKBuilt 1973 · S/N 17261440N20613Taber Carl L · Trumansburg, NYBuilt 1973 · S/N 17261441N20616Mcconnell Group LLC · Edwardsville, ILBuilt 1973 · S/N 17261442N20618Aerospatial LLC · Selah, WAS/N 17261443N2061ECak4 LLC · Uniontown, OHBuilt 1978 · S/N 17271139N20621Bryant Jeffrey M · Pell City, ALBuilt 1973 · S/N 17261444N20626Swingle Craig A · Hopewell, OHBuilt 1973 · S/N 17261447
Back to AD 80-25-07 R1