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.

N287NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4508 N287WRPi Sn1754 LLC · Fort Lauderdale, FLBuilt 2017 · S/N 1754 N288AFMod-Pac Corp · Portsmouth, NHBuilt 2023 · S/N 2288 N288AYJetran LLC · Horseshoe Bay, TXBuilt 2013 · S/N 1441 N288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 148 N288FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63137 N288NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4537 N288SEBig Wednesday Air LLC · Long Beach, CABuilt 2017 · S/N 1714 N2891Sarasota County Sheriffs Office · Sarasota, FLBuilt 2024 · S/N 57499 N289AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1455 N289FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63136 N289GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3016 N289NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2011 · S/N 4574 N28ADBlue Collar Inc · New York, NYBuilt 2013 · S/N 4284 N28BBCove Partners LLC · Santa Monica, CAS/N 57327 N28DCMbogo Energy LLC · Boerne, TXBuilt 1994 · S/N 139 N28KRValore Aviation LLC · Baton Rouge, LABuilt 2023 · S/N 2245 N28NXDooalot Pc-12 LLC · New York, NYBuilt 2023 · S/N 2228 N290AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 1480 N290CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40564 N290FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63135 N290GSBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 2038 N290JKD7 Roofing LLC · New Baden, ILBuilt 2023 · S/N 2300 N290NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2191 N290XCMojave Jet LLC · Wilmington, DES/N 290 N291AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 1502 N291DVFall River Aviation LLC · Corvallis, ORBuilt 2001 · S/N 560-5146 N291FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63134 N291FTMauna Holdings LLC · Newark, DEBuilt 2023 · S/N 2291 N291GXGlobal Crossing Airlines Inc · Miami, FLBuilt 2007 · S/N 3349 N291KYValera LLC · Mayfield, KYBuilt 2021 · S/N 2091 N291NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2206 N292AYBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 1512 N292FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63133 N292NVBank Of Utah Trustee · Salt Lake City, UTS/N 4891 N293AYBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2014 · S/N 1526 N293FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63132 N293NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4913 N293TWBedford Partners LLC · Oxford, CTBuilt 2011 · S/N 1293 N29401Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 29401 N294ARJet Midwest Inc · Kansas City, MOS/N 29404 N294DLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4138 N294FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63131 N294NGMjj Capital Management Inc · Ross, CAS/N 1294 N294NVBank Of Utah Trustee · Salt Lake City, UTS/N 4941 N295FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63130 N295NVBank Of Utah Trustee · Salt Lake City, UTS/N 4942 N296FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64056 N296NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 2674 N296VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5296

Back to AD 2012-26-15 R1