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.

N731BPBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 560-5802 N731NGEmmental Partners LLC · Hillsborough, CABuilt 2017 · S/N 1731 N732ANAmerican Airlines Inc · Fort Worth, TXS/N 31549 N732USAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1203 N7331GTotal Helicopters Unlimited · Stafford, VABuilt 2021 · S/N 57442 N733ARAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33524 N733SRSbr Flight Support LLC · Scottsdale, AZBuilt 2023 · S/N 2279 N733UWAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 1205 N734ARAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31480 N734KCorporate Jet Leasing Company LLC · Wichita, KSBuilt 2020 · S/N 586 N735ATAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 32439 N735SFSf Air LLC · Tulsa, OKBuilt 2014 · S/N 481 N735XLPjk Equipment Leasing LLC · Zelienople, PABuilt 2007 · S/N 560-5733 N736ATAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33538 N736KCorporate Jet Leasing Company LLC · Wichita, KSBuilt 2020 · S/N 587 N737DDegol Aviation Inc · Altoona, PABuilt 2006 · S/N 560-5638 N737USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1245 N738KCorporate Jet Leasing Co LLC · Wichita, KSBuilt 2020 · S/N 588 N738USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1254 N739BGBristow U S LLC · New Iberia, LABuilt 2013 · S/N 41350 N73FJTla73 LLC · Santa Rosa Beach, FLBuilt 1999 · S/N 73 N73RPTransportation Holdings IV LLC · Dallas, TXBuilt 2015 · S/N 5528 N74007United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29477 N740AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6411 N740AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22213 N740KCorporate Jet Leasing Company LLC · Wichita, KSS/N 589 N740TFTop Gun Air LLC · Pompano Beach, FLBuilt 2000 · S/N 074 N740UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1265 N7417Rigi Inc · Portsmouth, NHBuilt 2023 · S/N 2253 N741AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6617 N741NGAir Methods LLC · Greenwood Village, COBuilt 2017 · S/N 1741 N741UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1269 N742AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6692 N742PSBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1275 N742SPOur Plane LLC · Kingwood, TXBuilt 2011 · S/N 14501122 N743AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6739 N743TTJett-To Aviation LLC · Chester, NYFirst renewal noticeBuilt 2002 · S/N 218 N744AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22221 N744PBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1287 N745AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 6746 N745AXCargo Aircraft Management Inc · Wilmington, OHS/N 22222 N745KCrg LLC · Norman, OKS/N 245 N745KDChamp Charters LLC · Camden, DEBuilt 2008 · S/N 384 N745TTFlaghill LLC · Key West, FLBuilt 2000 · S/N 099 N745VJBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1289 N746ARJdm Aircraft LLC · Arlington, TXS/N 63 N746CXB Street Air LLC · Omaha, NEBuilt 2005 · S/N 560-5567 N746JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3622 N746PCAerozephyr LLC · Long Beach, CABuilt 2015 · S/N 560-6192 N746UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1297

Back to AD 2012-26-15 R1