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.

N5078GFresh Air Aviation Inc · Charlevoix, MIBuilt 1960 · S/N LF-8N5078NBemidji Aviation Services Inc · Bemidji, MNS/N LF-16N5078UBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-32N5079EBemidji Aviation Services Inc · Bemidji, MNS/N LF-52N507AYAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3712N507JTJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1240N507TFairchild Property Management LLC · Monterey, CABuilt 1968 · S/N TC-1111N507VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4832N507YVBank Of Utah Trustee · Salt Lake City, UTS/N 24607N5080GQuinlan John H DBA · Claxton, GABuilt 1962 · S/N LF-35N5080HBemidji Aviation Services Inc · Bemidji, MNBuilt 1961 · S/N LF-27N5080LBemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-59N508AYAmerican Airlines Inc · Fort Worth, TXBuilt 2008 · S/N 3740N508BCAlta 777 LLC · Salt Lake City, UTS/N 30873N508JLJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1257N508UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24744N508VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4950N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34N5098QM&L Engine LLC · Schriever, LABuilt 1971 · S/N 340-0024N509AYAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3796N509BCJet Midwest Inc · Kansas City, MOBuilt 2003 · S/N 33370N509CQBwp Aviation LLC · Nashville, TNBuilt 1993 · S/N 1233N509JBJetblue Airways Corporation · Long Island City, NYBuilt 2000 · S/N 1270N509KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 27659N509VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5062N50GBOviedo Juan M III · Oak Point, TXBuilt 1975 · S/N 340-0163N50LKTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 1994 · S/N 1252N50SBCobb Susie O · Fayetteville, TNBuilt 1978 · S/N TC-2134N510JBJetblue Airways Corp · Long Island City, NYBuilt 2000 · S/N 1280N510KTSch Aviation Inc Trustee · SporleS/N 120.117N510MGSuperior Transportation Associates Inc · Costa Mesa, CABuilt 1998 · S/N 1349N510SPKitty Hawk LLC · Fort Worth, TXBuilt 1993 · S/N 1183N510TFLang Eric O · Oklahoma City, OKBuilt 1978 · S/N 340A0499N510UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3858N510VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5207N5116MBend Aircraft Mechanics LLC · Bend, ORBuilt 1978 · S/N ME-39N511FClarke Kenneth J · Anchorage, AKBuilt 1963 · S/N TC-555N511KA1111 Giv LLC · Downey, CABuilt 1989 · S/N 1111N511VLWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5212N511VMRadler Glenn · Livingston, NJBuilt 1964 · S/N TC-785N5120RKrause Aviation LLC · Geneva, ILS/N TC-1816N512CCCd 357 LLC · Austin, TXBuilt 2001 · S/N 1446N512HPN512hp LLC · Dover, DEBuilt 1974 · S/N 340-0324N512JNAtares Funding LLC · Fisher Island, FLBuilt 1992 · S/N 48512N512VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5308N513DWright Aero Inc · Saint Cloud, MNBuilt 1976 · S/N 340A0048N513LSSpec Air LLC · Saint Petersburg, FLBuilt 1991 · S/N 1178N513SNM48513 LLC · Esters, FLBuilt 1994 · S/N 48513N513VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5322N5140JTruk Err Inc · Wilmington, DEBuilt 1975 · S/N 340-0530
Back to AD 95-26-15 R1