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.

N167USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1442 N168FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63100 N168GSG Delaplaine Enterprises LLC · Frederick, MDBuilt 2021 · S/N 560-6309 N168PDAdministracion De Los Servicios Generales · San Juan, PRBuilt 2013 · S/N 57161 N169DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29689 N169FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63101 N169SDBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5455 N169TCFlycle LLC · Brecksville, OHBuilt 2015 · S/N 4337 N169UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1455 N16FCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2071 N16HQ10ke LLC · Okeechobee, FLBuilt 2016 · S/N 1656 N16MFRegistered aircraftBuilt 2008 · S/N 5206 N16PCFlorida Digital Data LLC · Dover, DEBuilt 2014 · S/N 495 N16QSCavalier 2001 Holdings LLC · Oklahoma City, OKBuilt 2026 · S/N 560-6513 N16WWRegistered aircraftBuilt 2018 · S/N 57343 N1709AAndromeda Leasing I LLC · Purchase, NYS/N 24086 N170FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63102 N170USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1462 N171DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24759 N171DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29690 N171USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1465 N172AFDynasty Flight LLC · Portsmouth, NHBuilt 2022 · S/N 2172 N172DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24775 N172DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29691 N172FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63103 N172USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1472 N173CBer Company LLC · Albuquerque, NMBuilt 2023 · S/N 2256 N173DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29692 N173FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63104 N173NYBlf Aircraft Holdings LLC · Irvine, CABuilt 2007 · S/N 5149 N173USBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1481 N174DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24802 N174DZDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29693 N174EMWest States Leasing Inc · Medford, ORBuilt 2020 · S/N 57387 N174FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63105 N174USBank Of Utah Trustee · Salt Lake City, UTS/N 1492 N175DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24803 N175DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29696 N175FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63106 N175HGAsphalt Materials Inc · Indianapolis, INBuilt 2016 · S/N 541 N175JMKc Aviation Partners LLC · Wilmington, DES/N 28424 N175MXCrumpton Aviation LLC · Tulsa, OKBuilt 2014 · S/N 497 N175WAOsprey Aviation LLC · Preston, IDBuilt 2017 · S/N 1750 N176DLFive In Five LLC · Dallas, TXBuilt 2001 · S/N 560-5192 N176DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29697 N176FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 63107 N176TGCsc Delaware Trust Co Trustee · Wilmington, DES/N 512 N176UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1499 N177DNDelta Air Lines Inc · Atlanta, GABuilt 1991 · S/N 25122 N177DZDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29698

Back to AD 2012-26-15 R1