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.

N841DWSouth Coast Aviation Inc · Portland, ORBuilt 2001 · S/N 560-5177 N841FDFederal Express Corp · Memphis, TNBuilt 2025 · S/N 66267 N841HNQualitair LLC Trustee · MichelstadtBuilt 2023 · S/N 2305 N841JSFe Xl 5253 LLC · Kinston, NCBuilt 2002 · S/N 560-5253 N841MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29714 N841UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1545 N842AAstec Industries Inc · Chattanooga, TNBuilt 1999 · S/N 560-5042 N842MBMed Air LLC · Lawrenceville, GABuilt 2001 · S/N 179 N842MHDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 29715 N842UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1569 N843JSFe Encore Plus II LLC · Kinston, NCBuilt 2003 · S/N 560-5343 N843MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29716 N843UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1573 N844CBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 4350 N844GFDiamond A Administration Company LLC · Dallas, TXBuilt 2009 · S/N 4160 N844GTFx Mining LLC · Haines, AKBuilt 2014 · S/N 1480 N844JSFe5344 LLC · Kinston, NCBuilt 2003 · S/N 560-5344 N844MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29717 N844SJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4281 N844UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1581 N845FDFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66255 N845JSThese Pretzels Are Making Me Thirsty LLC · Kinston, NCBuilt 2001 · S/N 560-5180 N845MHDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29719 N845UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1585 N846FDFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66256 N846JSChinaberry Landing LLC · Sugar Hill, GABuilt 2003 · S/N 560-5355 N846UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1600 N847A8m Holdings LLC · Bloomfield, NEBuilt 1999 · S/N 560-5047 N847FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66257 N847JSJml Jet II LLC · Uvalde, TXBuilt 2003 · S/N 560-5320 N847RCRac Transcorp LLC · Lake Forest, ILBuilt 2011 · S/N 4215 N847UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1627 N847WESpalding Consulting LLC · Franklin, TNBuilt 2015 · S/N 1581 N848FDFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66258 N848JAD S Advisors Inc · Oak Park, ILBuilt 2004 · S/N 5047 N848TWTw Leasing LLC · Oxford, CTBuilt 2015 · S/N 1557 N848UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1647 N849FDFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66259 N849TWTw Leasing LLC · Oxford, CTBuilt 2015 · S/N 1551 N849UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1649 N849WCTxpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 1289 N84GH84golfhotel LLC · Floydada, TXBuilt 2015 · S/N 1544 N850FTHuff Air LLC · Uvalde, TXS/N 560-5807 N850JApex Aviation LLC · Knoxville, TNBuilt 2019 · S/N 1853 N850LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 4036 N850SWFlyco LLC · Fremont, CABuilt 2020 · S/N 2036 N850TCRt Falcon Enterprises LLC · Bloomfield Hills, MIBuilt 1999 · S/N 92 N850UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1653 N851ASUmb Bank Na Trustee · Salt Lake City, UTS/N 1185 N851GWTvpx Aircraft Soltions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 1851

Back to AD 2012-26-15 R1