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.

N560VFVictor Foxtrot LLC · Scott City, KSBuilt 2000 · S/N 560-5135 N560VSHillabrand Heir LLC · Greenville, SCBuilt 2000 · S/N 560-5066 N560WBFirst National Bank · Paragould, ARBuilt 2008 · S/N 560-5764 N560WG560wg LLC · Dover, DEBuilt 1999 · S/N 560-5028 N560WLTres Amigos Aviation LLC · Dover, DEBuilt 1998 · S/N 560-5012 N560XETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 560-5103 N560XLTextron Aviation Inc · Wichita, KSBuilt 1995 · S/N 706 N560ZFN560lj LLC · San Jose, CABuilt 2004 · S/N 560-5525 N561BERegistered aircraftBuilt 2026 · S/N 560-6511 N561JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1927 N561JLFalcon Aviation Ltd Co · San Diego, CABuilt 2004 · S/N 560-5361 N561PGTennessee Valley Authority · Chattanooga, TNBuilt 2017 · S/N 560-6225 N561SKJet Air Management LLC · Miami Beach, FLBuilt 2015 · S/N 5529 N561UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5317 N562AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5622 N562DDZoe Aviation Inc · Euless, TXBuilt 2000 · S/N 560-5108 N562HCH2c Air LLC · Cincinnati, OHBuilt 2003 · S/N 560-5350 N562JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1948 N562JLMonreve LLC · Jacksonville, FLBuilt 2002 · S/N 560-5248 N562LDCasey Co · Long Beach, CABuilt 2004 · S/N 560-5532 N562TSJ-Six Enterprises LLC-J-Six Aviation Holdings Seri · Seneca, KSBuilt 2001 · S/N 560-5178 N562UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5332 N562VPBruner Air LLC · Springfield, ILBuilt 2006 · S/N 560-5623 N563CSTulsa Xls LLC · Tulsa, OKBuilt 2005 · S/N 560-5563 N563DWDog Air LLC · Santa Clara, CABuilt 2014 · S/N 560-6169 N563JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2006 N563MGAviation Consultants · Nashville, TNBuilt 2014 · S/N 1511 N563UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5368 N563XPTextron Aviation Inc · Wichita, KSBuilt 2006 · S/N 560-5617 N564CHCardinal Glass Industries Inc · Ocala, FLBuilt 2011 · S/N 560-6092 N564JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2020 N564LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 40593 N564TATeam Aero LLC · Shawnee, KSS/N 560-5249 N564WS4way Split LLC · Bay Minette, ALBuilt 1998 · S/N 560-5014 N565CATextron Aviation Inc · Wichita, KSS/N 560-6523 N565HVHy-Vee Inc · West Des Moines, IABuilt 2019 · S/N 560-6269 N565JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2031 N565JMNational Oceanic And Atomospheric Administration · Lakeland, FLBuilt 2016 · S/N 5538 N565QSNetjets Sales Inc · Columbus, OHBuilt 2008 · S/N 560-5818 N565RHMiles To Go LLC · Quincy, MABuilt 2018 · S/N 560-6257 N566BRBonjamin Air LLC · Houston, TXBuilt 2025 · S/N 2451 N566FMidwest Ethanol Transport LLC · Granite Falls, MNBuilt 2005 · S/N 560-5606 N566GLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 1566 N566JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2042 N566JRBoeing Co · Ridley Park, PABuilt 2026 · S/N 41825 N566LAJilguero Owner Trust · Wilmington, DEBuilt 2011 · S/N 40798 N567AFRigi Inc · Portsmouth, NHS/N 1567 N567AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4567 N567ERSrei Aviation LLC · Billings, MTBuilt 2009 · S/N 1139 N567JRBoeing Co · Ridley Park, PABuilt 2026 · S/N 41826

Back to AD 2012-26-15 R1