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.

N660AWUS Bank Na Trustee · Boston, MABuilt 2000 · S/N 1234 N660HH94924 LLC · Medford, ORBuilt 2009 · S/N 5255 N660LFLife Flight Network LLC · Aurora, ORBuilt 2012 · S/N 1347 N660NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6804 N660UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27115 N661AWU S Bank Na Trustee · Boston, MABuilt 2000 · S/N 1284 N661AZAmazon.Com Services LLC · Seattle, WAS/N 29384 N661ECPalu Aviation LLC · Oklahoma City, OKBuilt 2007 · S/N 14501001 N661JBJetblue Airways Corp · Long Island, NYBuilt 2007 · S/N 3228 N661JMSas Aviation Holdings LLC · Scottsdale, AZBuilt 2003 · S/N 145730 N661LFLife Flight Network LLC · Aurora, ORBuilt 2014 · S/N 1505 N661MSLone Star Avalanche LLC · Marble Falls, TXBuilt 1987 · S/N 011 N661NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6867 N661UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27158 N662AWUS Bank National Association Trustee · Boston, MABuilt 2000 · S/N 1274 N662JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3263 N662LFLife Flight Network LLC · Aurora, ORBuilt 2015 · S/N 1587 N662NKSpirit Airlines LLC · Dania Beach, FLBuilt 2015 · S/N 6897 N662UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27159 N663AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1419 N663CBCb Aviation Inc · Ogden, UTBuilt 2006 · S/N 4058 N663GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27568 N663JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3287 N663NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 6994 N663UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 27160 N664AFAlfa Financial Corp · Montgomery, ALBuilt 2011 · S/N 560-6064 N664AVAvsa Leasing 3 · Wilmington, DEBuilt 2008 · S/N 3664 N664AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1621 N664LFLife Flight Network LLC · Aurora, ORBuilt 2016 · S/N 1655 N664NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7021 N664UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29236 N665AWU S Bank Na Trustee · Boston, MABuilt 2001 · S/N 1644 N665JBJetblue Airways Corp · Long Island City, NYBuilt 2007 · S/N 3348 N665JJUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 5126 N665NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7045 N665PVCedar Knoll Vineyards Inc DBA Palmaz Vineyards · Napa, CABuilt 2015 · S/N 57271 N665UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29237 N666CATvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 36157 N666JMBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2025 · S/N 2468 N666UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29238 N667AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1710 N667HFBd Plane Inc · Chicago, ILBuilt 1987 · S/N 25 N667KMEuroaviation Inc Trustee · KematenBuilt 2020 · S/N 57410 N667LFLife Flight Network LLC · Aurora, ORBuilt 2018 · S/N 1796 N667MCTextile Aviation LLC · Dalton, GABuilt 2011 · S/N 409 N667MZMprop Leasing A LLC · Wake Forest, NCBuilt 2016 · S/N 1667 N667NKSpirit Airlines LLC · Dania Beach, FLBuilt 2016 · S/N 7058 N667UAUnited Airlines Inc · Chicago, ILBuilt 1998 · S/N 29239 N668AFFaber Squared LLC · Portsmouth, NHBuilt 2016 · S/N 1668 N668AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1764

Back to AD 2012-26-15 R1