Skip to content

AD 2012-26-15 R1

Registered aircraft · 5,538

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.

N367DNDelta Air Lines Inc · Altanta, GABuilt 2019 · S/N 8713 N367NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0988 N367SPSamaritan'S Purse · Boone, NCBuilt 2006 · S/N 33510 N367UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 65790 N368DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8695 N368MBAffiliated Investments LLC · Auburn Hills, MIBuilt 2001 · S/N 161 N368NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2039 N368NGWeems Air LLC · Dalton, GAS/N 1368 N368NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0996 N368UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 65907 N369CRCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2024 · S/N 560-6369 N369DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8697 N369GAGulfstream Aerospace Corp · Savannah, GAS/N 4369 N369NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2047 N369NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1011 N369UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 66240 N36EPJsm At Falcon II LLC · Piscataway, NJBuilt 2001 · S/N 172 N36GXCarolina Cardinal Holdings LLC · Wilson, NCBuilt 2023 · S/N 2244 N36LTDohertys Toys Second LLC · Lakeland, FLBuilt 2024 · S/N 2425 N36NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25193 N36NGBsl Transport LLC · Salem, ORBuilt 2016 · S/N 1636 N36PJSteelman Aviation Assets LLC · North Las Vegas, NVBuilt 2021 · S/N 2114 N36SGAstra Beta Helicopter LLC · Newburgh, NYBuilt 2010 · S/N 41246 N36ZMStauf Air LLC · Germantown, TNBuilt 2016 · S/N 1640 N37018United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31680 N370AFRigi Inc · Portsmouth, NHBuilt 2024 · S/N 2370 N370DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8765 N370GAGulfstream Aerospace Corp · Savannah, GAS/N 4370 N370HAHawaiian Airlines Inc · Honolulu, HIBuilt 2014 · S/N 1511 N370NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2087 N370NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1037 N370RVAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 2008 · S/N 378 N370UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 66241 N371CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 25577 N371DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8763 N371JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5304 N371LLCritical Care Services Inc DBA · Blaine, MNBuilt 2010 · S/N 1240 N371NBDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2095 N371NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1535 N371UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65791 N372CMAirborne Maintenance And Engineering Serives Inc · Wilmington, OHBuilt 1992 · S/N 25575 N372DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8809 N372HLHl Aircraft LLC · Oklahoma City, OKS/N 597 N372NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1633 N372UPUnited Parcel Service Co · Louisville, KYBuilt 2020 · S/N 65908 N372XLTextron Aviation Inc · Wichita, KSBuilt 2025 · S/N 560-6372 N373CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1990 · S/N 24929 N373DGAttorney Aviation LLC · Dallas, TXBuilt 2001 · S/N 159 N373DXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8734 N373EZHawkins Aviation LLC · Boise, IDBuilt 2016 · S/N 1654

Back to AD 2012-26-15 R1