AD 2016-20-01

Registered aircraft · 188

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

N80KGBell Textron Inc · Fort Worth, TXS/N 57565N812LEMaricopa County · Phoenix, AZBuilt 2020 · S/N 57397N822AZArizona Department Of Public Safety · Phoenix, AZS/N 57439N83HHHopscotch One LLC · Millbrook, NYBuilt 2010 · S/N 56080N861NCAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 57239N862NCKeybank National Association · Superior, COBuilt 2014 · S/N 57242N87SJAir Biggie LLC · Bristol, VABuilt 2010 · S/N 57023N88DWUS Trinity Equipment LLC · Argyle, TXBuilt 2014 · S/N 57247N899NPNorthern Indiana Public Service Co LLC · Merrillville, INS/N 57477N905WMValiair Lc Trustee · Casper, WYS/N 57347N908KBWintrust Asset Finance Inc · Frisco, TXBuilt 2021 · S/N 57433N911AMEstado Libre Asociado De Puerto Rico · San Juan, PRS/N 57284N911AZState Of Arizona · Phoenix, AZS/N 57301N911DXAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 57377N911EDAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 57006N911JLJefferson Parish Sheriffs Office · Harvey, LABuilt 2012 · S/N 57096N911KXLendingclub Bank Na · Boston, MABuilt 2011 · S/N 57002N911NMSan Juan Regional Medical Center · Farmington, NMBuilt 2010 · S/N 57031N911VHCook County Sheriff'S Office · Chicago, ILBuilt 2024 · S/N 57524N911ZPCity Of Chicago Department Of Police · Chicago, ILBuilt 2024 · S/N 57505N917PDNew York City Police Department · Brooklyn, NYBuilt 2013 · S/N 57148N918PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57188N918TRExecutive Pl Solutions LLC · Salt Lake City, UTBuilt 2021 · S/N 57426N919PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57220N920PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57233N922STSan Tomo Inc · Stockton, CABuilt 2014 · S/N 57206N924SPGeorgia Dept Of Public Safety · Kennesaw, GABuilt 2013 · S/N 57151N9306BKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2022 · S/N 57453N947TRBell Textron Inc · Fort Worth, TXS/N 57560N961BHSierra Pacific Industries · Redding, CABuilt 2013 · S/N 57146N965KTWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 57020N965SPLouisiana State Police · Baton Rouge, LABuilt 2022 · S/N 57445N967BKBlack Knight Aviation Services LLC · Whitefish, MTBuilt 2011 · S/N 57074N983SVTotal Helicopters Unlimited · Stafford, VAS/N 57348N988FYTotal Helicopters Unlimited · Stafford, VABuilt 2021 · S/N 57444N98JC50 One Aviation LLC · San Juan, PRBuilt 2010 · S/N 56082N997BFBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 57236N9CRBanner Elk Aviation LLC · Banner Elk, NCBuilt 2013 · S/N 57149
Back to AD 2016-20-01