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.

N462UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1272 N463ACUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35299 N463AFBrammer Charles W Jr · Portsmouth, NHBuilt 2025 · S/N 2463 N463FXFlexjet LLC · Cleveland, OHBuilt 2010 · S/N 4182 N463UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1282 N4649KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1863 N464AFBryfly LLC · Portsmouth, NHBuilt 2025 · S/N 2464 N464FXFlexjet LLC · Cleveland, OHBuilt 2007 · S/N 4105 N464TTReagan Skies LLC · Lincoln, CABuilt 2014 · S/N 1464 N464UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1290 N465FXFlexjet LLC · Cleveland, OHBuilt 2010 · S/N 4208 N465UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1341 N4663KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 1865 N466FXFlexjet LLC · Cleveland, OHBuilt 2009 · S/N 4173 N466GAGulfstream Aerospace Corp · Savannah, GAS/N 4366 N466RHNordic Air LLC · Salem, ORBuilt 2020 · S/N 2031 N466UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1343 N467FXFlexjet LLC · Cleveland, OHBuilt 2009 · S/N 4156 N467GAGulfstream Aerospace Corp · Savannah, GAS/N 4367 N467UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1359 N468AMAmc 50 LLC · Chicago, ILS/N 074 N468FXFlexjet LLC · Cleveland, OHS/N 4300 N468GAGulfstream Aerospace Corp · Savannah, GAS/N 4368 N468LCCrenshaw Aviation LLC · Raleigh, NCBuilt 2020 · S/N 2009 N468UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1363 N469AFRigi Inc · Portsmouth, NHBuilt 2014 · S/N 1469 N469FXFlexjet LLC · Cleveland, OHBuilt 2009 · S/N 4151 N469MRBcrh LLC · Owasso, OKBuilt 2000 · S/N 560-5125 N469RRLegacy Aviation Inc · Camden, DEBuilt 2004 · S/N 5055 N469RSMdx Leasing LLC · Pompano Beach, FLBuilt 2000 · S/N 560-5082 N469UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1409 N46FBSfblic Aviation LLC · Jackson, MSS/N 560-6362 N46HADjt Equipment LLC · Cocoa Beach, FLBuilt 1999 · S/N 91 N46HBSunshining Aviation LLC · Wilmington, DEBuilt 1988 · S/N 42 N46MWCreamer Pilot Services LLC · Fayetteville, ARBuilt 2009 · S/N 2126 N470DCRance King Properties Inc · Long Beach, CABuilt 2006 · S/N 14500946 N470FXFlexjet LLC · Cleveland, OHS/N 479 N470MKBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 146 N470QSNji Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 4084 N470UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1427 N471ARAerotrust Services Corp Trustee · Wilmington, DEBuilt 2021 · S/N 2067 N471FXFlexjet LLC · Cleveland, OHBuilt 2015 · S/N 500 N471TNUmb Bank Na Trustee · Salt Lake City, UTS/N 28837 N471UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1432 N472FXFlexjet LLC · Cleveland, OHS/N 501 N472HLHl Aircraft LLC · Oklahoma City, OKBuilt 2020 · S/N 593 N472LJUsd Air LLC · Phoenix, AZBuilt 2025 · S/N 2470 N472TNUmb Bank Na Trustee · Salt Lake City, UTS/N 29863 N472UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1435 N473ECBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5473

Back to AD 2012-26-15 R1