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.

N76GATurbine Holdings II LLC · New York, NYBuilt 1999 · S/N 760498N76HHHallecopter LLC · Wilmington, DEBuilt 2010 · S/N 760807N76LDRotor-Time Aviation LLC · Condado, PRBuilt 2016 · S/N 8285N76PCSo Much For Subtlety LLC · Dover, DEBuilt 2005 · S/N 760597N76ZAN76za LLC · New York, NYBuilt 2007 · S/N 760653N770KCAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9960N7727FAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21473N772PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760730N773BGBristow LLC · Lake Charles, LABuilt 2009 · S/N 760773N773PAKaibab LLC · Kirkland, WABuilt 2005 · S/N 4010N773XGooseneck Inc · Heber City, UTBuilt 2009 · S/N 4773N777CTVertical Corp · Kalispell, MTBuilt 2001 · S/N 3395N779GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4630N779PAXebec LLC · Kirkland, WABuilt 2007 · S/N 4318N779XRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 8226N780GSAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7275N781BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 2024 · S/N 9448N781PPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2006 · S/N 760630N781RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760673N782BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 2017 · S/N 8404N782RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760666N783BCBroward County Sheriff'S Office · Fort Lauderdale, FLBuilt 2017 · S/N 8417N783MHBay Life Services Corp · Columbia, MDBuilt 2026 · S/N 21458N783RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760735N784LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2022 · S/N 21096N784PAKaibab LLC · Kirkland, WABuilt 2010 · S/N 7071N784RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760721N785PSale Reported · Robert, LASale reported, canceledBuilt 2006 · S/N 760635N785RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760639N786PAXebec LLC · Kirkland, WABuilt 2002 · S/N 3498N786RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760618N787RLGm Leasing Company LLC · Broussard, LABuilt 2009 · S/N 760778N789LPShier Aviation Corp · San Diego, CAS/N 7907N78BK2 Aircraft Holdings LLC · Pasadena, CAS/N 8545N790AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4298N791AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4335N792AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4362N793AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4413N7940KAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7895N794AEAir Evac Ems Inc · O Fallon, MOBuilt 2023 · S/N 9415N794AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4440N794PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760737N795AEAir Evac Ems Inc · O Fallon, MOBuilt 2023 · S/N 9462N796AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4550N797PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760742N798ACAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8088N798PPhi Health LLC · Tempe, AZBuilt 2007 · S/N 760685N7AJN315ja LLC · Anacortes, WABuilt 2023 · S/N 9315N7WWRegistered aircraftBuilt 2021 · S/N 21004N7ZSRogue Mountain LLC · Whitefish, MTBuilt 2007 · S/N 4361
Back to AD 2016-25-13