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.

N47AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1972 · S/N 340-0114N47SEHighlands Group LLC · Lahaina, HIS/N 465-34N47TGTan Industries LLC · Wilmington, DEBuilt 1980 · S/N TC-2343N47WCFly Girls Aviation LLC · Saint Amant, LABuilt 1959 · S/N TD-241N480MCAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 28812N480UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1555N480VRMmap LLC · Denver, COBuilt 1999 · S/N 1380N4811CPowers Chris · Houston, TXBuilt 1964 · S/N TC-760N48127United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28968N4818FCragg Philip A · Point Roberts, WABuilt 1981 · S/N WA311N481AVAircol 21 · Wilmington, DEBuilt 2010 · S/N 4381N481BCJahn481bc LLC · Miami, FLBuilt 1991 · S/N 340B-274N481CMCargo Aircraft Management Inc · Wilmington, OHS/N 26992N481MCAtlas Air Inc · Purchase, NYS/N 32339N481SCRjs Aviation LLC · Fort Myers, FLBuilt 1997 · S/N 1313N481UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1559N482MCAtlas Air Inc · Purchase, NYBuilt 2001 · S/N 32340N482UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1584N4833AEnoch Mark C · Rowlett, TXBuilt 1980 · S/N 340A1026N483UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1586N484UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1609N485GMGlobal Destinations LLC · Beaumont, TXBuilt 1997 · S/N 1311N485UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1617N4862JWicker Gregory B · Irmo, SCBuilt 1966 · S/N TC-1024N4867JNational Aero Services LLC · Helena, MTBuilt 1966 · S/N TE-276N4868JFoster Milton F · Dawson, GABuilt 1966 · S/N TE-277N4869JDls Aviation LLC · Gilmer, TXBuilt 1966 · S/N TE-281N486ACSoaring Soul LLC · Brainerd, MNBuilt 1974 · S/N TC-1662N486MHMh Group LLC · Duncan, OKBuilt 1978 · S/N 340A0481N486UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1620N487CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2004 · S/N 33768N487KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 340A0240N487UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1669N488UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1680N489MCAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 26553N489UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1702N48CEEssential Aviation Llcregistered · Hickory, KYBuilt 1958 · S/N TD-163N48GLGenesis Adventures LLC · Brea, CABuilt 1988 · S/N 1052N48SSiragusa Pamela L · Cypress, TXBuilt 1958 · S/N TD-40N4901UUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 2680N490UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1728N491AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29429N491UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1741N492UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1755N493UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1821N494AStotlar William B · Pinckneyville, ILBuilt 1967 · S/N TE-370N494UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1840N495JSP&P Air LLC · Salem, NHBuilt 1998 · S/N 1336N495MMAmazon.Com Services LLC · Seattle, WABuilt 2022 · S/N 67026N495UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1842
Back to AD 95-26-15 R1