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.

N353KKiewit Engineering Group Inc · Omaha, NEBuilt 2013 · S/N 459 N353LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5519 N353NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1828 N353NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 786 N354DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8332 N354KKiewit Engineering Group Inc · Omaha, NEBuilt 2013 · S/N 462 N354NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1833 N354NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 801 N354WA235pt LLC · Cape Girardeau, MOBuilt 2012 · S/N 1354 N355DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8359 N355FLBank Of Utah Trustee · Salt Lake City, UTS/N 2553 N355KKiewit Engineering Group Inc · Omaha, NEBuilt 2015 · S/N 518 N355NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1839 N355NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 807 N355SMAcedeuce Air LLC · Morganton, NCBuilt 2020 · S/N 560-6290 N356BKBk Albatross LLC · Lilburn, GABuilt 2020 · S/N 2041 N356DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8279 N356KKiewit Engineering Group Inc · Omaha, NEBuilt 2014 · S/N 2135 N356NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 818 N357DCAwas 3896 Trust · Wilmington, DES/N 3896 N357DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8339 N357ERErf Flight Services LLC · Corpus Christi, TXBuilt 2012 · S/N 1357 N357ETCajun Industries Holdings LLC · Baton Rouge, LABuilt 2024 · S/N 2384 N357FTFaith Technologies Inc · Menasha, WIBuilt 2024 · S/N 2357 N357FWFlorida Fish And Wildlife Conservation Commission · Lakeland, FLS/N 57312 N357HEHaynie Enterprises Inc · Henderson, NVBuilt 2010 · S/N 1203 N357JKDodson International Parts Inc · Rantoul, KSBuilt 2013 · S/N 1451 N357KKiewit Engineering Group Inc · Omaha, NEBuilt 2017 · S/N 552 N357MJJavier'S Group LLC · Aliso Viejo, CABuilt 1999 · S/N 560-5026 N357NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1875 N357NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 830 N357RBBell Textron Inc · Fort Worth, TXS/N 57559 N358CLIagcas LLC · Tucson, AZFirst renewal noticeS/N 28358 N358DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8316 N358NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1897 N358NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 832 N359AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24036 N359DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8370 N359FCPc-24 LLC · Park City, UTS/N 1483 N359KKiewit Engineering Group Inc · Omaha, NEBuilt 2014 · S/N 2140 N359NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 1923 N359NWDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 846 N359VFLegacy Air LLC · Johnson, KSBuilt 2012 · S/N 1359 N35AAFalcon Landing LLC · Hawthorne, CABuilt 2011 · S/N 5291 N35ASFlight Level Services LLC · Danville, KYBuilt 2013 · S/N 1412 N35DMArcadian Leasing LLC · Gary, INBuilt 2011 · S/N 4231 N35FJTfjg Air LLC · Virginia Beach, VAS/N 2008 N35GRWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 5183 N35JMVwg Open Skys LLC · Roswell, GABuilt 2006 · S/N 560-5613 N35RHHms Holdings LLC · Charlotte, NCBuilt 2011 · S/N 57035

Back to AD 2012-26-15 R1