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.

N25VRN25vr LLC · Portland, ORBuilt 2001 · S/N 152 N25XMMccluer Aviation LLC · North Las Vegas, NVBuilt 2019 · S/N 1896 N260FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67533 N260NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4104 N261FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67532 N261GEBank Of Utah Trustee · Salt Lake City, UTS/N 32790 N261HBChamonix Air LLC · Boulder, COBuilt 2010 · S/N 1261 N261NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4115 N261NXCitizens National Bank Of Texas · Waxahachie, TXBuilt 2020 · S/N 2061 N261PWPerryair LLC · New York, NYBuilt 2010 · S/N 5268 N262FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67531 N262NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4122 N2639UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62650 N263FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67530 N2644UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 63724 N2645UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64989 N264FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66869 N264SGAdventaire LLC · Minot, NDBuilt 2021 · S/N 2149 N264VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5264 N265CWOde Family Logistics LLC · Strongsville, OHBuilt 2005 · S/N 2042 N265FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66868 N265NXCmr3 Holdings LLC · Newark, DEBuilt 2011 · S/N 1265 N265SHSea Hunt Boat Mfg Co Inc · Sumter, SCBuilt 2013 · S/N 4290 N266AJMoore Investment Fund LLC · Belmont, OHBuilt 2004 · S/N 239 N266FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66867 N266NGBlue Horizon Ventures LLC · Gadsden, ALBuilt 2011 · S/N 1266 N267FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66866 N267JRKnight Sky II LLC · Miami, FLBuilt 1986 · S/N 23402 N267PTBlades & Bars LLC · Montrose, COBuilt 2022 · S/N 2169 N268FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66865 N269CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 25586 N269CRContinental Resources Inc · Baker, MTBuilt 2026 · S/N 560-6509 N269FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66864 N269NGRebel One LLC · Dover, DEBuilt 2010 · S/N 1243 N269WRWestgate Aviation Giv LLC · Orlando, FLBuilt 2007 · S/N 5153 N26CTCte Management LLC · Charlotte, NCS/N 533 N26NGAgb Warranty Services LLC · Warrenton, VABuilt 2013 · S/N 1426 N26NJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 139 N26QTQuiktrip Corporation · Tulsa, OKS/N 57461 N26RXRxjet Transportation Services Corp · Oxford, CTBuilt 2013 · S/N 5425 N26TBirmingham Bravo LLC · Birmingham, ALBuilt 2013 · S/N 560-6133 N26WRWonderful Orchards LLC · Shafter, CABuilt 2022 · S/N 2181 N26XLVal 67vc LLC · Green Cove Springs, FLBuilt 2011 · S/N 560-6086 N26XMAm Aviation LLC · Henderson, NVBuilt 2023 · S/N 2312 N27015United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28678 N270AFRigi Inc · Portsmouth, NHBuilt 2023 · S/N 2270 N270FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66249 N2710BDrglfg LLC · Denver, COBuilt 2018 · S/N 1809 N271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 189 N271ADBank Of Utah Trustee · Salt Lake City, UTS/N 0271

Back to AD 2012-26-15 R1