Registered aircraft · 954

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:2015-17-01-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:2015-17-01-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:2015-17-01-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:2015-17-01-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:2015-17-01-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:2015-17-01-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.

N62RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2015 · S/N 8032 N6302YTemsco Helicopter Inc · Ketchikan, AKBuilt 1998 · S/N 9007 N631SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2004 · S/N 3891 N631SDCounty Of Oakland · Pontiac, MIBuilt 2001 · S/N 3389 N632SDCounty Of Oakland · Oakland, MIBuilt 2002 · S/N 3519 N63CBBmf Heli LLC · Ogden, UTBuilt 1993 · S/N 2694 N63MCMissouri Department Of Conservation · Jefferson City, MOBuilt 2020 · S/N 8786 N63RCKootenai Business Properties LLC · Post Falls, IDBuilt 2019 · S/N 8760 N63RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7974 N641EGCity Of Fontana California · Fontana, CABuilt 2011 · S/N 7169 N642ABCatalyst Aviation LLC · Hammonton, NJBuilt 1991 · S/N 5498 N646PTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 4273 N64RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2017 · S/N 8346 N650HPKansas Highway Patrol · Topeka, KSBuilt 2024 · S/N 9397 N651CDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8868 N65RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2017 · S/N 8353 N661GKKip Construction Services Inc · Santa Clarita, CABuilt 2025 · S/N 9654 N661PDRegistration Pending · MeafordRegistration pendingBuilt 2006 · S/N 4029 N662PDRegistration Pending · MeafordontarioRegistration pendingBuilt 2006 · S/N 4069 N665PDLapd Air Support Division · Los Angeles, CABuilt 2007 · S/N 4319 N668MMColorado Highland Holdings LLC · Durango, COBuilt 1991 · S/N 2580 N668PDLos Angeles Police Dept Air Support Division · Los Angeles, CABuilt 2009 · S/N 4654 N669SEEmclo Charters Inc · Fort Myers, FLS/N 9156 N669TFRidgeline Aviation Inc · Cordova, AKBuilt 1982 · S/N 1484 N670HPKansas Highway Patrol · Topeka, KSBuilt 2024 · S/N 9483 N670TTerrible Herbst Inc · Las Vegas, NVBuilt 2021 · S/N 8985 N674TXTexas Department Of Public Safety · Austin, TXBuilt 2023 · S/N 9306 N6798Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8934 N680DGState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTBuilt 2007 · S/N 4310 N681ASRba LLC · Kimberly, IDBuilt 2001 · S/N 3328 N68RXReach Air Medical Services LLC · Mcclellan, CABuilt 2018 · S/N 8483 N694BBO307 LLC · Surprise, AZS/N 4005 N6968ATafy Consulting · Bristow, VABuilt 2013 · S/N 7530 N6974ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7459 N6977ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7463 N6981ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7472 N6987ATafy Consulting · Bristow, VABuilt 2014 · S/N 7834 N69XVQuantum Leasing LLC · Scottsdale, AZBuilt 2022 · S/N 9307 N6UXHelicopters Inc · Cahokia, ILBuilt 2003 · S/N 3749 N700PECentaurus Flight LLC · Ojai, CABuilt 2017 · S/N 8406 N702SASaf Ltd · Lihue, HIBuilt 2002 · S/N 3551 N702TXJ5 Aerospace LLC · Harrisburg, NCBuilt 2006 · S/N 4026 N703WPCity Of Los Angeles · Van Nuys, CABuilt 2017 · S/N 8362 N704RHValiair Lc Trustee · Casper, WYBuilt 2018 · S/N 8467 N704WPCity Of Los Angeles · Van Nuys, CABuilt 2017 · S/N 8369 N707MDEfw Inc · Fort Worth, TXBuilt 1984 · S/N 5306 N707WRDumont Associates Inc · Morris Plains, NJS/N 5239 N708HPNs Air Leasing LLC · Wilmington, DEBuilt 1999 · S/N 3244 N708PDEast Bay Regional Park District · Livermore, CABuilt 2008 · S/N 4390 N708SHDiscovery Helicopters LLC · Las Vegas, NVBuilt 2011 · S/N 7098

Back to AD 2015-17-01 R1