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.

N2353Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 2353 N235AFJ3b LLC · Portsmouth, NHBuilt 2022 · S/N 2235 N235FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7272 N235NVSunrise Asset Management LLC · Las Vegas, NVS/N 1130 N236FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7389 N236KRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4209 N236LPCrest Aviation II LLC · Newport Beach, CABuilt 2010 · S/N 4206 N236NXHj Aviation LLC · Vandalia, OHBuilt 2010 · S/N 1236 N237CMCargo Aircraft Management Inc · Wilmington, OHS/N 25584 N237EELes Schwab Warehouse Center Inc · Bend, ORBuilt 2013 · S/N 560-6149 N237GAOrange County/Sunbird Aviation LLC · Costa Mesa, CABuilt 2015 · S/N 5523 N237GRRed Flag Two Ltd · Miamisburg, OHBuilt 2006 · S/N 4055 N237SFCrt Aviation LLC · Fayetteville, NCBuilt 2022 · S/N 2152 N237TP237tp LLC · Statesboro, GABuilt 2019 · S/N 1867 N238FRBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7458 N238LLAlphinity Air LLC · Wilmington, DEBuilt 2020 · S/N 2013 N238LMBcp Fa Ap LLC · Providence, RIBuilt 1999 · S/N 039 N238NVUmb Bank Na Trustee · Salt Lake City, UTS/N 2133 N238SMExcel Leasing LLC · Excelsior, MNBuilt 2002 · S/N 560-5238 N239AXAviation8 LLC · Carle Place, NYBuilt 1987 · S/N 39 N239AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27450 N239MJG4sp Holdings LLC · West Palm Beach, FLBuilt 2005 · S/N 5095 N239NVUmb Bank N A Trustee · Salt Lake City, UTS/N 2144 N239SRApple Realty Group Inc · Richmond, VABuilt 2006 · S/N 2049 N239TCPrincipal Leasing Company LLC · Raleigh, NCBuilt 2008 · S/N 560-5817 N23DQJfb3 LLC · Atlanta, GABuilt 2007 · S/N 5148 N23GMMain Line Executive Travel LLC · Haverford, PABuilt 2018 · S/N 1827 N23LXSoft Cloud Consulting LLC · North Salt Lake, UTBuilt 2008 · S/N 560-6010 N23NENorthwestern Corp DBA · Sioux Falls, SDS/N 539 N23QSRegistered aircraftS/N 560-6519 N240PWOak Street Aviation LLC · Wichita, KSBuilt 2015 · S/N 1550 N2415National Nuclear Security Administration · Las Vegas, NVBuilt 2024 · S/N 41586 N241AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27451 N241CHTtx 2 LLC · Las Vegas, NVBuilt 2011 · S/N 4217 N241LJDouble Whiskey Aviation LLC · Midland, TXS/N 241 N242GMTrans-Exec Air Service Inc · Van Nuys, CABuilt 2007 · S/N 5123 N242NGPanhandle Telecommunication Systems Inc · Guymon, OKBuilt 2010 · S/N 1242 N242SGReppert Capital Management LLC · Houston, TXBuilt 2009 · S/N 1108 N243TXTexas Department Of Public Safety · Austin, TXBuilt 2012 · S/N 1328 N244Eight Hills LLC · Seattle, WABuilt 2011 · S/N 1307 N244FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67549 N245BDBs Farms Aviation LLC · Menlo Park, CABuilt 2007 · S/N 5165 N245DJLtlvsd LLC · Wilmington, DES/N 560-5662 N245FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67548 N245FHRke Log LLC · Baytown, TXS/N 393 N245GRGwr Aviation LLC · Houston, TXBuilt 2001 · S/N 175 N245HCHillsborough County Sheriffs Office · Tampa, FLBuilt 2025 · S/N 2450 N245KLear 245 LLC · Fayetteville, ARBuilt 2005 · S/N 269 N245NVSunrise Asset Management LLC · Las Vegas, NVS/N 1550 N245PEReack Aviation LLC · Wilmington, DEBuilt 2010 · S/N 1245

Back to AD 2012-26-15 R1