Skip to content

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

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.

N723FRAlc A321 8640 LLC · Camden, DEBuilt 2018 · S/N 8640 N723JGFriends In The Skies LLC · Dallas, TXBuilt 2010 · S/N 560-6069 N723UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1109 N724ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31548 N724AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6153 N724FShazam Travel LLC · Saint Augustine, FLBuilt 2017 · S/N 1724 N724FSSmith Frank Ford Jr · Wilmington, DEBuilt 2005 · S/N 2033 N724GTCoral One LLC · Orlando, FLS/N 560-5564 N724HSAirhawk LLC · Clearwater, FLBuilt 2015 · S/N 1527 N724MPCanary Holdings LLC · Lexington, KYBuilt 2018 · S/N 560-6248 N724UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1122 N725ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 41666 N725BDBdg Aircharter Inc · Syosset, NYBuilt 2008 · S/N 14501034 N725MSBlue Doors Property Management LLC · Matthews, NCBuilt 2019 · S/N 560-6273 N725UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 1135 N725XLHogs Fly LLC · Crystal Lake, ILBuilt 2007 · S/N 560-5725 N7268JSouthern California Emergency Medicine · Yucaipa, CABuilt 2015 · S/N 1561 N726ANAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 31550 N726APMedical Supply X LLC · Coats, NCBuilt 2016 · S/N 1608 N726AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6174 N726MDBristow LLC · Lake Charles, LABuilt 2013 · S/N 41320 N726MJMed Air LLC · Lawrenceville, GABuilt 2000 · S/N 104 N726NGCsb Aviation LLC · Monroe, LABuilt 2017 · S/N 1726 N7274LHybrid 1 LLC · Lakeland, FLS/N 1124 N727ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33541 N727KFParadise Holdings LLC · Scottsdale, AZBuilt 2021 · S/N 2064 N727PJBlack Hat Ventures Pp LLC · Naples, FLBuilt 2001 · S/N 560-5184 N727SJDataone Systems LLC · Dallas, TXBuilt 2012 · S/N 5388 N727TEMillrock Aviation Financial LLC · Danbury, CTBuilt 2008 · S/N 5223 N728ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 31553 N728AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6209 N728ECChouest Air Inc · Cut Off, LABuilt 2013 · S/N 5439 N728MHM/I Homes Of Delaware LLC · Columbus, OHBuilt 2015 · S/N 4346 N728PH728 Services LLC · New York, NYBuilt 2007 · S/N 14500985 N729ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33127 N729BMAig Partners LLC · Carson City, NVBuilt 2017 · S/N 954 N729JBJetblue Airways Corp · Long Island City, NYS/N 3572 N729LSUS Government · Washington, DCBuilt 2023 · S/N 2323 N72HLHl Aircraft LLC · Oklahoma City, OKBuilt 2017 · S/N 556 N72SEFlyse LLC · Newark, DEBuilt 2021 · S/N 2123 N72SGAero Air Charter Holding LLC · Pensacola, FLBuilt 2004 · S/N 560-5508 N72XLGate Precast Co · Jacksonville, FLBuilt 2011 · S/N 560-6072 N730ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 31554 N730AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6132 N730KCorporate Jet Leasing Company LLC · Wichita, KSBuilt 2019 · S/N 584 N730NGVon B LLC · Columbia, MOBuilt 2017 · S/N 1730 N730TWTw Leasing LLC · Oxford, CTBuilt 2015 · S/N 1516 N730USAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1182 N730VMBristow LLC · Lake Charles, LABuilt 2014 · S/N 41362 N731ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 33523

Back to AD 2012-26-15 R1