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.

N221FFGayas LLC · Lowell, MABuilt 2009 · S/N 5221 N221JRNorthview Aviation LLC · The Woodlands, TXBuilt 2012 · S/N 4257 N221MDSwiss Air LLC · Camp Hill, PABuilt 2014 · S/N 1465 N221NGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2112 N221NXMassive Prints Inc · Rancho Dominguez, CABuilt 2022 · S/N 2213 N221RCBtfd LLC · Reno, NVBuilt 2015 · S/N 1540 N221UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30552 N221VFAgustawestland Philadelphia Corp · Philadelphia, PAS/N 41633 N221VPPicabo Leasing LLC · Picabo, IDBuilt 2004 · S/N 560-5363 N221WRWagner Richard S · Plano, ILBuilt 2008 · S/N 360 N221XXN221yy Corp Trustee · Wilmington, DEBuilt 2009 · S/N 1128 N2220MObsidian Leasing LLC · Lehi, UTBuilt 2020 · S/N 2002 N222DEOtter Air Services LLC · Grand Rapids, MIBuilt 2022 · S/N 2173 N222GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5222 N222NEHigher Cause LLC · Grand Rapids, MIBuilt 2000 · S/N 110 N222UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30553 N222ZZMissaglia Aviation LLC · Rochester, NYBuilt 2008 · S/N 4137 N223AEmmanuel Group · North Wilkesboro, NCS/N 5583 N223KRBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 41340 N223LMLgp Hidden Oaks LLC · Fulshear, TXBuilt 2008 · S/N 1050 N223UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30224 N2243UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63723 N2244Post-Tension Services Of Texas LLC · Dallas, TXBuilt 2008 · S/N 1009 N224BHBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4241 N224GBBrb Leasing LLC · Dallas, TXBuilt 2006 · S/N 307 N224JWSouthern Multifoods Inc · Jacksonville, TXBuilt 2012 · S/N 560-6120 N224KDK-D Leasing Inc · Scottsdale, AZBuilt 2002 · S/N 560-5261 N224LDCloud Enterprise Holdings LLC · Roslyn Heights, NYBuilt 2006 · S/N 14500971 N224NCCollier Companies Aviation LLC · Gainesville, FLS/N 42 N224NVSunrise Asset Management LLC · Las Vegas, NVS/N 1694 N224SBBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 102 N224SLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 1252 N224UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30225 N2250UUnited Airlines Inc · Chicago, ILBuilt 2019 · S/N 66590 N2251UUnited Airlines Inc · Chicago, ILBuilt 2020 · S/N 66591 N225AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30434 N225NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25194 N225UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30554 N226AFTaylor - Smartt LLC · Portsmouth, NHBuilt 2022 · S/N 2226 N226JMLakeside Industries Inc · Issaquah, WABuilt 2016 · S/N 560-6208 N226NGValiair Limited Co Trustee · Casper, WYBuilt 2010 · S/N 1226 N226NWAnd Dont Call Me Shirley LLC · Boise, IDBuilt 2008 · S/N 1051 N226SWNicklaus LLC · Bristol, VABuilt 2021 · S/N 560-6306 N226TDStone Horse Aviation Services LLC · Chatham, MABuilt 2009 · S/N 1183 N226UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 30226 N226VLSetna Io LLC · Lincolnshire, ILS/N 2264 N2274RHarrison Rosemary J · Houston, TXBuilt 2021 · S/N 57422 N227AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27448 N227BMCone Aviation Cs LLC · Ocala, FLBuilt 2019 · S/N 1879 N227CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 26327

Back to AD 2012-26-15 R1