OpenAirDocs.org
AD 85-14-06 R1

Registered aircraft · 952

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
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:85-14-06-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:85-14-06-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.

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