AD 2016-20-06

Registered aircraft · 453

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-06')
    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-06')
  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.

N757MCSmtv Ontario LLC · San Diego, CABuilt 2002 · S/N 1498N763DBTrans Exec Air Service Inc · Van Nuys, CABuilt 1989 · S/N 1114N765RMBd Giv 2 LLC · New York, NYBuilt 1991 · S/N 1170N769MMBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 1369N76EJValiair Lc Trustee · Casper, WYS/N 1033N770KSBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1989 · S/N 1093N774MBVida Trade And Management Group · Charlotte, NCS/N 339N7799TSn 1474 LLC · Wilmington, DEBuilt 2002 · S/N 1474N779LCTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1970 · S/N 88N779LDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 1238N77FKOcean Aviation 26 LLC · Great Neck, NYBuilt 1998 · S/N 1357N789TNNorth Bristol Partners LLC · Santa Monica, CABuilt 1994 · S/N 1240N78AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 1362N78ETSteven Brothers Aviation LLC · Wichita, KSBuilt 1993 · S/N 1217N7DKAerotrust Services Corp Trustee · Wilmington, DEBuilt 1995 · S/N 1260N800ARPerpetual Aviation LLC · Arlington, VABuilt 2002 · S/N 1496N800BHHabib Aviation LLC · West Palm Beach, FLBuilt 2000 · S/N 1407N804NANasa Neil A Armstrong Flight Research Center · Edwards, CAFirst renewal noticeBuilt 1982 · S/N 344N805FTG4sp Blackbox Holdings LLC · North Palm Beach, FLBuilt 1999 · S/N 1374N808CFBoss 8 LLC · Fort Worth, TXBuilt 1991 · S/N 1176N808MFCd 321 LLC · Cypress, TXBuilt 2001 · S/N 1448N808NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1984 · S/N 424N80QJRegistered aircraftBuilt 1998 · S/N 1333N810TMNomad Air LLC · Dover, DEBuilt 2002 · S/N 1483N814NANasa Neil A Armstrong Flight Research Center · Edwards, CAS/N 1199N815DTAviation Development Group LLC · Kalispell, MTS/N 1085N816SPJmd Aviation LLC · Jupiter, FLBuilt 2001 · S/N 1452N818MECape Clear LLC · Westboro, MABuilt 2000 · S/N 1431N818VBPhoenix Air Group Inc · Cartersville, GABuilt 1980 · S/N 302N819VDAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 2004 · S/N 1535N825CPPilgrim Air 2 LLC · Van Nuys, CABuilt 1999 · S/N 1378N826RPTbf Group Aviation LLC · Great Neck, NYBuilt 2003 · S/N 1507N827GAPpg Industries Inc · West Mifflin, PABuilt 1999 · S/N 1391N828AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 415N840ERTikchik LLC · Anchorage, AKBuilt 1988 · S/N 1049N842PAValiair Ltd Co Trustee · Casper, WYBuilt 1988 · S/N 1057N850RTFlying Owl Aviation LLC · Lewisville, TXBuilt 1997 · S/N 1324N852SPStephens Pipe & Steel LLC · Jamestown, KYBuilt 1997 · S/N 1309N857PRTravel Link LLC · Vienna, VAS/N 348N857STSeminole Tribe Of Florida · Hollywood, FLBuilt 1998 · S/N 1345N85GC4lions LLC · Chula Vista, CABuilt 1991 · S/N 1161N85WDAerovision-Logos Aircraft Holdings Vii Corp · Dover, DEBuilt 1987 · S/N 1008N869MDEmo Systems LLC · Wilton Manors, FLBuilt 1999 · S/N 1363N869SCPerennial Investments Inc · Anaheim, CABuilt 1994 · S/N 1236N86MSAb Jet Co II LLC · Metairie, LABuilt 2000 · S/N 1406N874CTrans-Exec Air Service Inc · Van Nuys, CABuilt 1993 · S/N 1219N876GLGlj Aviation LLC · Pompano Beach, FLBuilt 2001 · S/N 1454N877AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2001 · S/N 1461N877LCLetica Leasing LLC · Rochester Hills, MIBuilt 1991 · S/N 1165N878SMWorld Heir Inc · College Park, GABuilt 1997 · S/N 1319
Back to AD 2016-20-06