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.

N867FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 40673 N867JSJs Jet III LLC · Kinston, NCBuilt 2002 · S/N 560-5292 N867WKendall Hunt Publishing Co Inc · Dubuque, IABuilt 2006 · S/N 560-5601 N868BBBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 4051 N868BSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4080 N868CGIrg Wings LLC · Los Angeles, CABuilt 2010 · S/N 560-6077 N868CMRegistered aircraftBuilt 2021 · S/N 560-6316 N868JSEverything Aviation LLC · Trabuco Canyon, CABuilt 2001 · S/N 560-5152 N868VBNw Holdings LLC · Saint Joseph, MOBuilt 2008 · S/N 354 N868XLWhiskey Delta Bravo LLC · Fort Myers, FLBuilt 2005 · S/N 560-5603 N869DLN869dl LLC · Kansas City, MOBuilt 2006 · S/N 5136 N869JSExclusive Jets LLC · Kinston, NCBuilt 2001 · S/N 560-5159 N86ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5270 N86DQQdn Aviation LLC · New Canaan, CTBuilt 2014 · S/N 5489 N86TKMeridian Air LLC · Andover, NJBuilt 2012 · S/N 1371 N86WUUmphrey Air LLC · Beaumont, TXBuilt 2001 · S/N 560-5198 N8701LCitation Oil & Gas Corp · Houston, TXBuilt 2007 · S/N 560-5751 N870ARFtc Air Holdings LLC · Tampa, FLBuilt 1997 · S/N 46 N870CMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5076 N870FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 40676 N870JSFe Xls 6200 LLC · Kinston, NCBuilt 2015 · S/N 560-6200 N870ZPotomac Corp · Wheeling, ILBuilt 2001 · S/N 193 N871DGYc Powder LLC · Turlock, CABuilt 2013 · S/N 1402 N871FDFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66260 N871RFScheels All Sports Inc · Fargo, NDBuilt 2001 · S/N 560-5219 N871UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1971 N872BBStampede Aviation LLC · Phoenix, AZBuilt 2004 · S/N 560-5515 N872DGAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2020 · S/N 2035 N872FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66262 N872JSSea Jay LLC · Raleigh, NCBuilt 2002 · S/N 560-5302 N872UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1986 N873AJPharos Air LLC · Newark, DES/N 1601 N873CAAc Spe 12 LLC · Orlando, FLBuilt 2012 · S/N 1348 N873FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 40679 N873UAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 2004 N874FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66263 N874HSSchunneman Harry James · Houston, TXBuilt 2018 · S/N 1794 N874UAUmb Bank Na Trustee · Salt Lake City, UTS/N 2008 N874VTGolden Goat LLC · Southern Pines, NCBuilt 1997 · S/N 161 N875FDFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66264 N875TMTai Leasing Inc · Mckinney, TXBuilt 2015 · S/N 5526 N875UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2200 N876ADRegistered aircraftBuilt 2017 · S/N 560-6240 N876FDFederal Express Corp · Memphis, TNBuilt 2019 · S/N 40682 N876LFInhs Leasing Company LLC · Aurora, ORBuilt 2009 · S/N 1159 N876RAParminter Investments LLC · Wilmington, DEBuilt 2002 · S/N 560-5231 N876UAUnited Airlines Inc · Chicago, ILBuilt 2004 · S/N 2203 N876UCRegistered aircraftBuilt 2006 · S/N 560-5652 N877FDFederal Express Corp · Memphis, TNBuilt 2018 · S/N 40683 N877NGCheeky Aviation LLC · Summit, NJBuilt 2019 · S/N 1877

Back to AD 2012-26-15 R1