OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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.

N64APD&N Holdingsinc · Boca Raton, FLBuilt 1974 · S/N 31-7405178N64AZAlpha Zulu Tailwinds LLC · Fair Oaks, CABuilt 1964 · S/N 272753N64BACisco Beach Investments Inc · Dover, DES/N 34-7970341N64DWNavation LLC · Lauderhill, FLBuilt 1973 · S/N TH-306N64KBLee Scott D · Mcloud, OKBuilt 1959 · S/N 23-1665N64KTKlute Jordan · Omaha, NEBuilt 1976 · S/N 340A0045N64LAHanner Investments LLC · Appling, GAS/N TH-978N64LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N TH-1749N64MKraft Ronald S · Albuquerque, NMBuilt 1956 · S/N 23-534N64RPCoe Administrators LLC · Oshkosh, WIBuilt 1978 · S/N TJ-169N64TD377 Supplies LLC · Argyle, TXS/N 30-170N64VBTamworth Aviation LLC · Allen, TXBuilt 1973 · S/N TH-305N64WRAlesia Holdings LLC · Beaumont, TXBuilt 2001 · S/N TH-1981N64YBRegistration Pending · Wasilla, AKRegistration pendingS/N 30-331N6500DAztec Adventures LLC · Cape Coral, FLBuilt 1960 · S/N 27-181N6501PGarcia Perez Alberto Carlos · Houston, TXBuilt 1964 · S/N 27-2489N6503YShe-Rat Aviation Inc · Wilmington, DEBuilt 1967 · S/N 27-3791N6504YLiebig Bryan H · Sacramento, CABuilt 1967 · S/N 27-3792N650BDV1vr LLC · Saint Louis, MOBuilt 1979 · S/N 414A0404N650DBValiair Limited Company Trustee · Casper, WYBuilt 1982 · S/N 414A0853N650PA-Z Leasing LLC · Kenosha, WIBuilt 1965 · S/N 27-2793N650RMAcci Aviation LLC · Conway, ARBuilt 1978 · S/N 414A0031N650THAri Ben Aviator Inc · Fort Pierce, FLBuilt 1982 · S/N ME-427N65118Stormy Pilots LLC · Saint Thomas, VIBuilt 1982 · S/N TJ-437N6518YKiley Clement · Plainville, MAS/N 27-3808N651DBJgm Icarus LLC · Centennial, COBuilt 1976 · S/N 340A0089N651SDMontana Jj LLC · Big Sky, MTFirst renewal noticeBuilt 2020 · S/N 20800663N6527CSunrise Site Development Corp · Bristow, VABuilt 1978 · S/N 34-7870163N6527YAll Pro Electrical Contractors Inc · Silsbee, TXBuilt 1967 · S/N 27-3800N652KWHauser Zachary D · Camp Verde, AZBuilt 1969 · S/N 310P0077N652PLN652pl LLC · Saint Joseph, MOBuilt 1980 · S/N 31-8052159N652SCSale Reported · Glen Allen, VASale reportedBuilt 1970 · S/N 31P-14N6531YSmith Henry C III · Essexville, MIBuilt 1967 · S/N 27-3824N6537AYellow Jacket Aero LLC · Plymouth, MNBuilt 1978 · S/N 27-7954002N653JRMosquito Air LLC · Lewes, DEBuilt 1979 · S/N 340A0726N653SCDeaton Dennis · Glen Allen, VAS/N 31P-25N653TCHomer Mark · Grosse Ile, MIBuilt 1964 · S/N TC-653N6544AMatthews Aviation LLC · Hardinsburg, KYS/N 27-7954005N6545LBohn Martin · Lawton, OKS/N TC-679N6549AGregory P Cook LLC · Spokane, WABuilt 1978 · S/N 27-7954006N654MDProfessional Storage Inc · Hobe Sound, FLBuilt 1976 · S/N 27-7754018N6554XFly Like A Boss Aviation LLC · Minden, NVBuilt 1967 · S/N 310L0179N6557CFox Kilo Aviation Corp · Pompano Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 347670184N655CFCarter James W · Dyersburg, TNBuilt 1964 · S/N 337-0016N655JDaum Colton A · Scottsbluff, NEBuilt 1968 · S/N TC-1090N655RJBostic Curtis E · Prestonsburg, KYBuilt 1970 · S/N TC-1331N6561ARandolph Fielding A M · Jackson, TNBuilt 1978 · S/N 27-7954008N6561CTrtc Aviation LLC · Byron Center, MIBuilt 1977 · S/N 414A0014N6561YN6561y LLC · Auburn, ALBuilt 1968 · S/N 27-3858N6573KGta Air Inc · Addison, TXBuilt 1983 · S/N TH-1369
Back to AD 2004-25-16 R1