Skip to content

AD 2012-26-15 R1

Registered aircraft · 5,538

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N345JWJ W Didado Electric LLC · Akron, OHBuilt 2013 · S/N 1434 N345KMJdr Management LLC · Boca Raton, FLBuilt 1986 · S/N 3 N345LCN276gc LLC · Carlsbad, CABuilt 2007 · S/N 5145 N345MAMed Air LLC · Wilmington, DEBuilt 1999 · S/N 054 N345NBDelta Air Lines Inc · Atlanta, GAS/N 1774 N345NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 399 N345NXSlipstream Aviation Partners LLC · Benton, KYBuilt 2012 · S/N 1345 N345PJk Aero LLC · Gilbert, IABuilt 2023 · S/N 2271 N345PFFranklin Mountain Assets II LLC · El Paso, TXBuilt 2021 · S/N 560-6310 N345RFClaire Air LLC · Carol Stream, ILBuilt 2021 · S/N 2075 N345RLMasthead Transportation LLC · Orange Park, FLBuilt 2001 · S/N 180 N346CCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2016 · S/N 560-6219 N346CMMassey Cleber J · Abilene, TXBuilt 2014 · S/N 471 N346DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8227 N346NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1796 N346XLRolling Green Enterprises LLC · St Louis Park, MNBuilt 2003 · S/N 560-5346 N347AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26264 N347CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26995 N347DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8250 N347NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1800 N347NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 408 N348AFKirkland Messina Inc · Portsmouth, NHBuilt 2023 · S/N 2348 N348DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8258 N348NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1810 N348NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 410 N349CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26996 N349DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8233 N349GXSilver Aviation LLC · Deerfield Beach, FLBuilt 2024 · S/N 2349 N349NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1815 N349NWDelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 417 N34BAPrvny Pluk LLC · Houston, TXBuilt 1956 · S/N G-797 N34FEMid-Atlantic Interstate Transmission LLC · Akron, OHBuilt 2021 · S/N 57420 N34HSHs Arrow LLC · Indianapolis, INBuilt 2015 · S/N 5514 N34LRLr2 Holdings LLC · Columbia, MDBuilt 2024 · S/N 2369 N34MJN34mj LLC · Des Moines, IABuilt 2019 · S/N 1856 N34UTUnited Therapeutics Corp · Res Triangle Park, NCBuilt 2015 · S/N 57265 N350DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8207 N350GDGulfstream Leasing LLC · Savannah, GABuilt 2005 · S/N 4023 N350NADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 418 N351CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25201 N351DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8251 N351NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1820 N351NWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 766 N352DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8283 N352KKiewit Engineering Group Inc · Omaha, NEBuilt 2014 · S/N 2138 N352NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1824 N352NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 778 N353ASAersale Inc · Coral Gables, FLS/N 553 N353AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25198 N353DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8322

Back to AD 2012-26-15 R1