OpenAirDocs.org
AD 2016-25-13

Registered aircraft · 1,086

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:2016-25-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-25-13')
  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.

N717CLR S Losee Helicopter Lc · Orem, UTBuilt 2003 · S/N 3720N718PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760686N719GFWarfield Aviation II LLC · San Francisco, CABuilt 2021 · S/N 21035N71HPOhio Department Of Public Safety · Columbus, OHBuilt 2018 · S/N 8515N71LCLee County Sheriffs Office · Fort Myers, FLBuilt 2015 · S/N 7994N720FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2019 · S/N 8726N723PVN23pv LLC · Redondo Beach, CABuilt 2010 · S/N 7055N724PHPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760688N725AHBering Air Inc · Nome, AKBuilt 2024 · S/N 9592N725LLMilton S Hershey Medical Center · Hershey, PABuilt 2013 · S/N 6983N725MFArrow Aviation Company LLC · Broussard, LABuilt 2002 · S/N 760532N725PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760692N726AKTriple Tango LLC · Carlsbad, NMFirst renewal noticeBuilt 2019 · S/N 8776N728AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7248N72EHHelinet Aviation Services LLC · Van Nuys, CABuilt 2008 · S/N 760712N72HPOhio Department Of Public Safety · Columbus, OHBuilt 2015 · S/N 7978N730FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2022 · S/N 9350N730TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 21431N736AMAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7366N73LCLee County Sheriffs Office · Fort Myers, FLBuilt 2022 · S/N 9356N740AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 9308N740FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2025 · S/N 9774N740KCCity Of Oklahoma City · Oklahoma City, OKBuilt 2023 · S/N 9411N741ACAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7845N741AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 9323N741CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8821N741SMLas Vegas Metropolitan Police Department · North Las Vegas, NVBuilt 2022 · S/N 9180N745PPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 760619N745VTRegistered aircraftBuilt 2022 · S/N 21117N74WLCorpat Inc · Missoula, MTBuilt 2019 · S/N 8763N751AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4455N752AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4472N753AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4483N753EDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8924N753PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760726N754AMUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 4650N754LArrow Aviation Co LLC · Broussard, LAS/N 760754N755AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4500N759MMTrevor Corp DBA · Grayslake, ILBuilt 2007 · S/N 6777N759PPhi Health LLC · Tempe, AZBuilt 2007 · S/N 760690N760KCCity Of Oklahoma City · Oklahoma City, OKBuilt 2025 · S/N 9739N763AEAmerican Helicopters LLC · Kirkland, WABuilt 2014 · S/N 7789N763KMAviation Trust Co LLC · Oklahoma City, OKBuilt 2022 · S/N 9261N764AMNorth Flight Aero Med · Grand Rapids, MIBuilt 2009 · S/N 760764N764MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8411N765MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8423N766MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8428N768AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2009 · S/N 760710N769PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760671N76FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2005 · S/N 760585
Back to AD 2016-25-13