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.

N271CMCargo Aircraft Management Inc · Wilmington, OHS/N 22319 N271FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66250 N271NVAllegiant Air LLC · Las Vegas, NVBuilt 2006 · S/N 2932 N272AYAersale Inc · Coral Gables, FLBuilt 2000 · S/N 0333 N272BGFalcon Landing LLC · Hawthorne, CABuilt 2007 · S/N 5164 N272FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66242 N272HLHl Aircraft LLC · Oklahoma City, OKBuilt 2017 · S/N 558 N272JMAlta 777 LLC · Salt Lake City, UTS/N 27652 N272NGCactus Land Development LLC · Fountain Hills, AZBuilt 2011 · S/N 1272 N272NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 2995 N2737UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62647 N273ATisma Holdings Inc · Fairfax, VABuilt 2010 · S/N 5273 N273FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66243 N273LPKalitta Charters LLC · Ypsilanti, MIBuilt 2001 · S/N 185 N273NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3076 N273TATanimura & Antle Fresh Foods Inc · Salinas, CABuilt 2015 · S/N 525 N2747UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64991 N2748UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64994 N2749UUnited Airlines Inc · Chicago, ILBuilt 2019 · S/N 66589 N274FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 66244 N274NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3079 N2758WSunrise Aviation LLC · Fayetteville, ARS/N 2066 N275BTDs-Mf Management LLC · Norman, OKBuilt 2024 · S/N 560-6365 N275ERContinuum Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 275 N275FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66245 N275MSkyknight LLC · Greeneville, TNBuilt 2006 · S/N 4048 N275NVSunrise Asset Management LLC · Las Vegas, NVS/N 2807 N276FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66251 N276GXFalcon Msn 2695 Trust · Wilmington, DEBuilt 2006 · S/N 2695 N276HDRussoms Cloud Server LLC · Montgomery, ALBuilt 2023 · S/N 2276 N276HSBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 41517 N276JMAlta 777 LLC · Salt Lake City, UTS/N 27636 N276LJExpedite Aviation LLC · Westerville, OHBuilt 2001 · S/N 156 N276NVAllegiant Air LLC · Las Vegas, NVBuilt 2019 · S/N 8671 N277FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66246 N277GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 2480 N277NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3205 N277XXBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 177 N278FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66247 N278GHTdsair LLC · Fishers, INBuilt 2001 · S/N 141 N278GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1954 N278JMJlm Aviation LLC · Winthrop, MEBuilt 2012 · S/N 1367 N278NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4253 N278XL560xl LLC · Newark, DEBuilt 2002 · S/N 560-5278 N279FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66252 N279NVSunrise Asset Management LLC · Las Vegas, NVS/N 5250 N279SHMeneses Enterprises LLC · Houston, TXBuilt 2019 · S/N 5605 N279WRTelemachus LLC · New York, NYBuilt 2014 · S/N 5497 N27AFAir4 Aviation LLC · Houston, TXBuilt 1997 · S/N 45 N27AXN27ax LLC · Tulsa, OKBuilt 2001 · S/N 147

Back to AD 2012-26-15 R1