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.

N158ECHhh Aviation LLC · Des Moines, IABuilt 2001 · S/N 186 N158FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63097 N158SKNokomis Airways LLC · Camden, DEBuilt 2019 · S/N 560-6267 N159ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7034 N159FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 42732 N159PDAdministracion De Los Servicios Generales · San Juan, PRBuilt 2013 · S/N 57160 N159RBBristow LLC · Lake Charles, LABuilt 2012 · S/N 41281 N15BYJetmax Associates LLC · Miami, FLBuilt 2002 · S/N 199 N15MPMkam Aviation LLC · Sioux Falls, SDBuilt 2000 · S/N 560-5062 N15QCJetran LLC · Horseshoe Bay, TXS/N 36307 N15QSBaron Charter Service LLC · Oklahoma City, OKBuilt 2026 · S/N 560-6512 N1600WFlattop Aviation LLC · San Francisco, CABuilt 2018 · S/N 1812 N1602Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29694 N1603Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29695 N1604RDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30180 N1605Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30198 N16065Delta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30199 N160ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7069 N160FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63098 N161AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7085 N161FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43553 N161UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1403 N1621MLybl Air LLC · Billings, MTBuilt 2019 · S/N 1846 N162AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6621 N162FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43632 N162UWAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1412 N1630ABank Of Utah Trustee · Salt Lake City, UTS/N 1630 N163AAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6866 N163FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 62499 N163USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1417 N164CMaroon & Gold LLC · Albuquerque, NMBuilt 2009 · S/N 1074 N164FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43554 N164NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6909 N164RDIsland Park Aviation LLC · Fargo, NDBuilt 2022 · S/N 2225 N164SLife Flight Network LLC · Aurora, ORBuilt 2009 · S/N 1164 N165DSTextron Aviation Inc · Wichita, KSBuilt 2014 · S/N 560-6175 N165FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 62500 N165NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6956 N165PDAdministracion De Los Servicios Generales · San Juan, PRBuilt 2013 · S/N 57163 N165USAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 1431 N166AFGeiger Holdings Inc · Portsmouth, NHBuilt 2022 · S/N 2166 N166FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 43633 N166NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 6973 N166RDIsland Park Aviation LLC · Fargo, NDS/N 560-5740 N1677Le Loop LLC · Naples, FLBuilt 2017 · S/N 1677 N167ADGrok Air LLC · Miami Beach, FLBuilt 2010 · S/N 4197 N167ANAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 7013 N167FEFederal Express Corp · Memphis, TNBuilt 2018 · S/N 63099 N167JNJnf Aviation LLC · Pasadena, TXBuilt 2012 · S/N 560-6100 N167TVTeam Unicorn LLC · Hingham, MABuilt 2013 · S/N 5428

Back to AD 2012-26-15 R1