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.

N758USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1348 N759ASoutheast Aviation LLC · Knoxville, TNBuilt 2021 · S/N 606 N759ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32638 N75AX711 Holdings LLC · Oklahoma City, OKBuilt 2018 · S/N 569 N75CCNbi LLC · New Bremen, OHBuilt 2005 · S/N 5065 N75FPSpyksma John C Trustee · Plainview, TXBuilt 2014 · S/N 461 N75JMJast Air LLC · Wilsonville, ORBuilt 2001 · S/N 123 N75KXCarmax Enterprise Services LLC · Richmond, VABuilt 2022 · S/N 608 N75MNRegistered aircraftBuilt 2018 · S/N 563 N75MTMag Aviation Sales LLC · Akron, OHBuilt 2021 · S/N 605 N75MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 274 N75NDOdin Aero LLC · Fargo, NDBuilt 2017 · S/N 1701 N75NGTwodog LLC · Los Angeles, CABuilt 2012 · S/N 1375 N75PSSnow Peak Ventures LLC · Spanish Fork, UTBuilt 2007 · S/N 560-5719 N75RPTransportation Holdings III LLC · Dallas, TXBuilt 2014 · S/N 5460 N75SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 573 N75TFBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 5333 N75TPCrimson Excel LLC · Wilmington, DES/N 560-6216 N75UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2017 · S/N 560 N75VPInternational Aircraft Sales LLC · Fort Lauderdale, FLBuilt 2013 · S/N 467 N75WHJet Sports Aviation LLC · Tampa, FLBuilt 2008 · S/N 1031 N75XL5437 Holdings LLC · Houston, TXBuilt 2000 · S/N 560-5079 N75XPRedd Air LLC · Vancouver, WABuilt 2000 · S/N 118 N76010United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29480 N76021United Airlines Inc · Chicago, ILBuilt 2010 · S/N 39776 N76054United Airlines Inc · Chicago, ILBuilt 2000 · S/N 29449 N76055United Airlines Inc · Chicago, ILBuilt 2001 · S/N 29450 N76062United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29457 N76064United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29459 N76065United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29460 N760ANAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 31477 N760CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24753 N760EDLimnes Aviation LLC · Hillsboro, ORBuilt 2001 · S/N 560-5201 N760GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 68186 N760JBJetblue Airways Corp · Long Island City, NYBuilt 2008 · S/N 3659 N760USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1354 N761AJAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 31478 N761CKKalitta Air LLC · Ypsilanti, MIBuilt 1989 · S/N 24752 N761CXCargo Aircraft Management Inc · Wilmington, OHBuilt 1985 · S/N 22318 N761GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 69033 N762ANAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 31479 N762USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1358 N763ANBoeing Co · Renton, WAS/N 31480 N763AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4763 N763EPLeonardo Helicopters US Corp · Philadelphia, PAS/N 41643 N763JBJetblue Airways Corp · Long Island, NYBuilt 2008 · S/N 3707 N763USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1360 N764ANBoeing Co · Renton, WAS/N 32439 N764USUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1369 N765ANAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 32879

Back to AD 2012-26-15 R1