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.

N338NGJet Sales Of Stuart LLC · Stuart, FLS/N 1338 N338NVSunrise Asset Management LLC · Las Vegas, NVS/N 2378 N338NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 360 N338QTBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1382 N339DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8128 N339ETTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4295 N339JMHd Landing LLC · Dover, DEBuilt 2007 · S/N 5178 N339LSLas Vegas Sands Corp · Las Vegas, NVBuilt 2007 · S/N 5166 N339NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1709 N339NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 367 N33DRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2022 · S/N 2185 N33EHTextron Aviation Inc · Wichita, KSS/N 560-6520 N33LVMd Air LLC · Wilmington, DEBuilt 2014 · S/N 4316 N33NXSilver Lake Ne LLC · Park City, UTBuilt 2017 · S/N 1733 N33ZBSpot And Stalk LLC · Missoula, MTBuilt 2014 · S/N 1476 N340DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8180 N340NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1714 N340NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 372 N340SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 2043 N340YYValiair Lc Trustee · Casper, WYS/N 764 N341AEConquest Express LLC · Libertyville, ILBuilt 2012 · S/N 2132 N341DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8134 N341HBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 341 N341KKiewit Engineering Group Inc · Omaha, NEBuilt 2019 · S/N 576 N341NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1738 N341NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 380 N341WAGeosouthern Energy Corp · The Woodlands, TXBuilt 2012 · S/N 1341 N342AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 1342 N342BLChandler (U S A) Inc · Chandler, OKBuilt 2003 · S/N 5605342 N342DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 8159 N342KKiewit Engineering Group Inc · Omaha, NEBuilt 2014 · S/N 2143 N342NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1746 N342NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 381 N342PEMfrg LLC · Plymouth, MNBuilt 2012 · S/N 1342 N342SGMhs 3-2-1 Go LLC · Saint Louis, MOS/N 231 N342SPAero Bronco LLC · Boise, IDS/N 484 N343DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8200 N343LHLaboratory Corporation Of America Holdings · Burlington, NCBuilt 2024 · S/N 2343 N343NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1752 N343NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 387 N344CMCargo Aircraft Management Inc · Wilmington, OHS/N 28745 N344DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8171 N344NBDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 1766 N344NWDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 388 N344RSU S Bank Na Trustee · Hartford, CTBuilt 2013 · S/N 5444 N345AVAircol 20 · Wilmington, DEBuilt 2010 · S/N 4345 N345BHTb Equico LLC · Houston, TXBuilt 2000 · S/N 100 N345DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 8191 N345FMModern Industrial Services Inc · Beaumont, TXBuilt 2001 · S/N 151 N345GCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 2121

Back to AD 2012-26-15 R1