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

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

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.

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

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.

N710FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2019 · S/N 8702 N711JHJack Harter Helicopters Inc · Lihue, HIBuilt 2001 · S/N 3397 N712CACatalyst Aviation LLC · Hammonton, NJBuilt 1987 · S/N 5362 N713CACatalyst Aviation LLC · Hammonton, NJS/N 5363 N717CCHillsborough County Sheriffs Office · Tampa, FLBuilt 2026 · S/N 9900 N717CDHillsborough County Sheriffs Office · Tampa, FLBuilt 2018 · S/N 8505 N718WAWings Air Helicopters LLC · West Harrison, NYS/N 5695 N719AKMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1995 · S/N 2884 N71HDHelinet Aviation Services LLC · Van Nuys, CABuilt 2004 · S/N 3849 N71HPOhio Department Of Public Safety · Columbus, OHBuilt 2018 · S/N 8515 N71LCLee County Sheriffs Office · Fort Myers, FLBuilt 2015 · S/N 7994 N720FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2019 · S/N 8726 N725AHBering Air Inc · Nome, AKBuilt 2024 · S/N 9592 N726AKTriple Tango LLC · Carlsbad, NMBuilt 2019 · S/N 8776 N72HPOhio Department Of Public Safety · Columbus, OHBuilt 2015 · S/N 7978 N72LCLee County Sheriffs Office · Fort Myers, FLBuilt 1992 · S/N 2628 N730FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2022 · S/N 9350 N735SHSouthwest Geologic Survey LLC · Mesquite, NVBuilt 2012 · S/N 7315 N737JCPacific Copter Inc · Tamarac, FLS/N 9822 N73HPOhio State Highway Patrol · Columbus, OHBuilt 1998 · S/N 3130 N73LCLee County Sheriffs Office · Fort Myers, FLBuilt 2022 · S/N 9356 N740FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2025 · S/N 9774 N740KCCity Of Oklahoma City · Oklahoma City, OKBuilt 2023 · S/N 9411 N741CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8821 N741SMLas Vegas Metropolitan Police Department · North Las Vegas, NVBuilt 2022 · S/N 9180 N744HDU S Helicopters Inc · Marshville, NCBuilt 1981 · S/N 1449 N745MHMansfield Heliflight Inc · Milton, VTS/N 4975 N745RHUnited Helicopter Leasing LLC · Honolulu, HIBuilt 1982 · S/N 2047 N745SHKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2012 · S/N 7455 N746RHUnited Helicopter Leasing LLC · Honolulu, HIBuilt 1992 · S/N 2603 N74WLCorpat Inc · Missoula, MTBuilt 2019 · S/N 8763 N751AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4455 N752AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4472 N752CHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1986 · S/N 1906 N753AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4483 N753EDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8924 N754AMUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 4650 N755AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4500 N760KCCity Of Oklahoma City · Oklahoma City, OKBuilt 2025 · S/N 9739 N763AEAmerican Helicopters LLC · Kirkland, WABuilt 2014 · S/N 7789 N764MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8411 N765MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8423 N766MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8428 N770KCAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9960 N773XGooseneck Inc · Heber City, UTBuilt 2009 · S/N 4773 N775MAMercy Air Helicopter Inc · Fort Lauderdale, FLBuilt 1984 · S/N 1802 N775TCUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3622 N777CTVertical Corp · Kalispell, MTBuilt 2001 · S/N 3395 N779CPChaparral Air Group · Grapevine, TXBuilt 2001 · S/N 3452 N779GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4630

Back to AD 85-14-06 R1