AD 2016-08-20

Registered aircraft · 309

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-08-20')
    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-08-20')
  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.

N741AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 9323N773PAKaibab LLC · Kirkland, WABuilt 2005 · S/N 4010N779PAXebec 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 7275N784PAKaibab LLC · Kirkland, WABuilt 2010 · S/N 7071N786PAXebec LLC · Kirkland, WABuilt 2002 · S/N 3498N7940KAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7895N794AEAir Evac Ems Inc · O Fallon, MOBuilt 2023 · S/N 9415N795AEAir Evac Ems Inc · O Fallon, MOBuilt 2023 · S/N 9462N798ACAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8088N7ZSRogue Mountain LLC · Whitefish, MTBuilt 2007 · S/N 4361N801MHSunshine Helicopters Inc · Puunene, HIBuilt 2002 · S/N 3654N802MHWorld Trade Enterprises LLC · Lucas, TXBuilt 2003 · S/N 3707N805MHAirstar Leasing LLC · Henderson, NVBuilt 2004 · S/N 3799N806MHAirstar Leasing LLC · Henderson, NVBuilt 2004 · S/N 3833N807MHAirstar Leasing LLC · Henderson, NVBuilt 2005 · S/N 3912N808MHAirstar Leasing LLC · Henderson, NVBuilt 2005 · S/N 3914N809MHAirstar Leasing LLC · Henderson, NVS/N 3927N810HWMed-Trans Corp · Denton, TXBuilt 2014 · S/N 8048N810MHAirstar Leasing LLC · Henderson, NVS/N 3949N811HWMed-Trans Corp · Denton, TXBuilt 2012 · S/N 7425N812HWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 8036N812MHAirstar Leasing LLC · Henderson, NVS/N 3956N813AMAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7735N814MHAirstar Leasing LLC · Henderson, NVS/N 4020N815MHAirstar Leasing LLC · Henderson, NVS/N 4022N816MHMustang Leasing LLC · Henderson, NVS/N 4038N817MHMustang Leasing LLC · Henderson, NVS/N 4125N818MHMustang Leasing LLC · Henderson, NVS/N 4131N821MHMustang Leasing LLC · Henderson, NVBuilt 2006 · S/N 4134N822MHMustang Leasing LLC · Henderson, NVBuilt 2006 · S/N 4142N823CRIron Blonde LLC · Lewes, DEBuilt 2020 · S/N 8902N823MHMustang Leasing LLC · Henderson, NVBuilt 2006 · S/N 4158N824MHMustang Leasing LLC · Henderson, NVS/N 4173N826AHAurora Air LLC · Kalispell, MTBuilt 2022 · S/N 9249N82AHArrow Aviation Company LLC · Broussard, LABuilt 2023 · S/N 9361N832GCZuni LLC · Kirkland, WABuilt 2013 · S/N 7667N833GCXebec LLC · Kirkland, WABuilt 2013 · S/N 7747N834GCAmerican Helicopters LLC · Kirkland, WABuilt 2014 · S/N 7829N835GCZuni LLC · Kirkland, WABuilt 2014 · S/N 7833N836GCMonarch Enterprises Inc · Kirkland, WABuilt 2014 · S/N 8012N837GCMonarch Enterprises Inc · Kirkland, WABuilt 2008 · S/N 4637N846MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4248N847MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4266N848MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4290N849MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4313N850MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4327N851MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4340N852MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4356
Back to AD 2016-08-20