OpenAirDocs.org
AD 2012-26-15 R1

Registered aircraft · 5,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:2012-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:2012-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.

N923GSGreat Southern Bank · Springfield, MOBuilt 2006 · S/N 560-5624N923JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 5960N923JEUnder Par LLC · Overland Park, KSBuilt 1999 · S/N 094N923JVOffice 1 Air LLC · Las Vegas, NVBuilt 2023 · S/N 2297N923UPBoeing Co · Renton, WABuilt 2026 · S/N 68369N923USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6543N924SPGeorgia Dept Of Public Safety · Kennesaw, GABuilt 2013 · S/N 57151N924UPBoeing Co · Renton, WAS/N 68370N924USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6569N925BWCobblestone Aviation LLC · Neenah, WIBuilt 2004 · S/N 560-5507N925JBJb Aviation LLC · Park City, UTBuilt 2004 · S/N 251N925SDShipman Holdings I LLC · Dallas, TXBuilt 2014 · S/N 1478N925UPBoeing Co · Renton, WAS/N 70801N925UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6613N925VHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 31282N925ZGElliott Electric Supply Inc · Nacogdoches, TXBuilt 2010 · S/N 1248N926EPAgustawestland Philadelphia Corp · Philadelphia, PABuilt 2026 · S/N 41626N926JCJcd Leasing LLC · Orlando, FLBuilt 2000 · S/N 106N926MB519sp LLC · Woodmere, NYBuilt 2008 · S/N 5197N926UPBoeing Co · Renton, WAS/N 70802N926UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6618N92709Ashla Equipment Holdings LLC · Dallas, TXBuilt 2014 · S/N 4315N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196N927JCM13 Holding LLC · Hawthorne, CABuilt 2008 · S/N 1012N927SKCrosley Aviation LLC · Warsaw, INBuilt 1999 · S/N 051N927UPBoeing Co · Renton, WAS/N 70803N927UWAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6625N928AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7515N928CFBzt Consulting LLC · Scottsdale, AZBuilt 2007 · S/N 560-5705N928GNrs Leasing LLC · American Fork, UTBuilt 2025 · S/N 2471N928GCWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5239N928NGN928ng LLC · Coralville, IABuilt 2008 · S/N 1028N928NJPeoples Choice Consulting LLC · Laguna Beach, CABuilt 2004 · S/N 5013N928PGTw Leasing LLC · Oxford, CTBuilt 2020 · S/N 2058N929AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7525N929CHMetro Aviation Inc · Shreveport, LABuilt 2010 · S/N 1249N929JBJetblue Airways Corp · Long Island City, NYBuilt 2014 · S/N 6031N929UPBoeing Co · Renton, WAS/N 70804N92DZFdjb Holding LLC · Surprise, AZBuilt 2008 · S/N 1087N92LABaxter Investment Company LLC · Morristown, NJBuilt 2003 · S/N 5002N92MZKuwinda Air LLC · Midland, TXBuilt 2011 · S/N 1288N92NGWestern Aircraft Inc · Boise, IDBuilt 2010 · S/N 1192N92WKN92wk LLC · Houston, TXBuilt 2010 · S/N 1188N93003Umb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5704N9306BKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2022 · S/N 57453N930AUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7539N930CC4 Eagles LLC · Tampa, FLBuilt 2007 · S/N 2078N930UPBoeing Co · Renton, WAS/N 70805N931AMAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7541N931DCCdt Ventures Group LLC · Riverside, CABuilt 2005 · S/N 4013
Back to AD 2012-26-15 R1