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.

N213GPc12ng LLC · Cartersville, GABuilt 2011 · S/N 1260 N213KPMaroon & Gold LLC · Albuquerque, NMBuilt 2008 · S/N 1019 N213TGBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4219 N213UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30219 N2140UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62651 N2142UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63722 N214ALAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 1327 N214GGRegistered aircraftBuilt 2017 · S/N 1732 N214LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 41 N214MGMullet And Grits II LLC · Muskogee, OKBuilt 2012 · S/N 1339 N214NXLife Flight Network LLC · Aurora, ORBuilt 2010 · S/N 1214 N214TGTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2007 · S/N 328 N214UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30220 N215NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1292 N215PRSalang Aviation LLC · Corpus Christi, TXBuilt 2006 · S/N 315 N215RECompton Kincaid LLC · Wilmington, DEBuilt 2004 · S/N 215 N215UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30221 N216BGBrasfield & Gorrie LLC · Birmingham, ALBuilt 2011 · S/N 560-6083 N216UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30549 N217MJMtk Leasing LLC · Woodburn, ORBuilt 2002 · S/N 217 N217UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 30550 N218CRegistered aircraftBuilt 2024 · S/N 2340 N218HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5587 N218NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1229 N218PETourico Holiday Flights LLC · Maitland, FLBuilt 2010 · S/N 1218 N218UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30222 N219CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24358 N219JLFoundation Holdings LLC · Jonesboro, ARBuilt 2005 · S/N 267 N219NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1255 N219RBPauli-Mar Investment Co · Warren, MIBuilt 2006 · S/N 2058 N219TFMaple Holdings LLC · Kansas City, MOBuilt 2013 · S/N 4292 N219TXTexas Department Of Public Safety · Austin, TXBuilt 2015 · S/N 1575 N219UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30551 N219XN6049s LLC · Fullerton, CABuilt 2021 · S/N 2119 N21EHRegistered aircraftBuilt 2007 · S/N 5141 N21HMIheartmedia Management Services Inc · New York, NYBuilt 1988 · S/N 41 N21LHBda Air LLC · New Castle, DEBuilt 2009 · S/N 560-5822 N21NBNorthbound Air LLC · Fayetteville, ARBuilt 2006 · S/N 2045 N21NXKnobelsdorff Aviation LLC · Goodhue, MNBuilt 2013 · S/N 1421 N21UGiven To Fly Holdings LLC · West Chicago, ILS/N 5379 N21UCUnited Co · Bristol, VABuilt 2014 · S/N 5484 N21WLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2022 · S/N 2157 N220BGBrasfield & Gorrie LLC · Birmingham, ALBuilt 2016 · S/N 560-6215 N220DFFalcon Aviation Z LLC · Great Neck, NYBuilt 1998 · S/N 69 N220LERaythom LLC · Wilmington, DEBuilt 2001 · S/N 5605173 N220NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2000 · S/N 1262 N220UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30223 N220VPCjsmhc 1 LLC · Encinitas, CABuilt 2004 · S/N 560-5359 N220XTBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 29739 N221DEOtter Air Services LLC · Grand Rapids, MIBuilt 2021 · S/N 2077

Back to AD 2012-26-15 R1