OpenAirDocs.org
AD 95-26-15 R1

Registered aircraft · 5,440

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:95-26-15-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:95-26-15-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.

N455MArnold Curtis L II · Corsicana, TXBuilt 1965 · S/N TC-975N455QSouthern Utah University · Cedar City, UTBuilt 1972 · S/N TC-1441N455UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1105N455WGAlliance Aviation Group LLC · Wilmington, DEBuilt 1992 · S/N 1205N455ZSparta Aviation Group LLC · Saint Petersburg, FLBuilt 1994 · S/N 1235N4568NBergren Scott W Trustee · Walnut Creek, CABuilt 1978 · S/N 340A0549N456DLGt Aviation LLC · Mountain Home, ARBuilt 1972 · S/N TC-1461N456JMLandmark Aviation Services LLC · Sarasota, FLBuilt 1974 · S/N 340-0535N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319N456UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1128N456WPMatagorda Production Co · Westhoff, TXBuilt 1979 · S/N 340A0766N4577LLucas John · Norco, CABuilt 1972 · S/N 340-0115N4578NAviation International LLC · El Paso, TXBuilt 1978 · S/N 340A0553N4579NSeven Eight Juliet LLC · Edmond, OKBuilt 1978 · S/N 340A0479N457AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 25448N457DMMajor Development LLC · Cedaredge, COBuilt 1978 · S/N 340A0554N457DSBest Aircraft Deals LLC · Salt Lake City, UTS/N 1077N457UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1146N45838United Airlines Inc · Chicago, ILS/N 397N4589NGeneric Implant Solutions LLC · Pratt, KSBuilt 1978 · S/N 340A0556N4589STeebee Aviation LLC · Hixson, TNBuilt 1975 · S/N TC-1902N458BAAlpha Aviation Holding Group LLC · Raleigh, NCBuilt 1975 · S/N TC-1830N458CLBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 340B-458N458UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1163N4599FCcs Flight Services LLC · Benton Harbor, MIS/N 340A0652N459UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1192N45CWRobertson Scott · Chappell Hill, TXBuilt 1970 · S/N TC-1319N45PRAslesen Leasin LLC · Halstad, MNBuilt 1966 · S/N LJ-145N45TFWave Transportation LLC · Middletown, DEBuilt 1982 · S/N 340A1507N4604NS O W Aviation LLC · Crystal River, FLBuilt 1980 · S/N 340A1016N460AKTangier Services LLC · Mill Valley, CABuilt 2000 · S/N 1413N460UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1248N461UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1266N4621KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1902N462CMN462cm Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 26985N462UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1272N4638ATropical Air Lease LLC · Hialeah, FLBuilt 1971 · S/N TC-1408N463UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1282N4647SJnjz Enterprises LLC · The Woodlands, TXBuilt 1975 · S/N TC-1910N4649KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1863N464MCAtlas Air Inc · Purchase, NYBuilt 1992 · S/N 26341N464UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1290N464VCraig Michael · Port Orchard, WAS/N TC-1028N4650SMeno Brian P · Collinwood, TNBuilt 1975 · S/N TC-1907N465MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24784N465PAPhoenix Air Group Inc · Cartersville, GABuilt 1988 · S/N 120.108N465PEHoyle Jason R · Grove, OKBuilt 1966 · S/N TE-112N465TWSierra American Corp · Wilmington, DES/N 23465N465UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1341N4663KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1865
Back to AD 95-26-15 R1