AD 2017-20-01

Registered aircraft · 341

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:2017-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:2017-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.

N87KBKkb Holdings LLC · Wilmington, DEBuilt 2003 · S/N 331N880CHEcho Acquisitions LLC · Dover, DES/N 168N887SGN45ax LLC · Tulsa, OKBuilt 2001 · S/N 174N889CAGracon Express LLC · Lafayette, COBuilt 2001 · S/N 132N890LTLife Time Inc · Chanhassen, MNBuilt 1997 · S/N 19N892TXByte Me Transportation Inc · Fort Pierce, FLBuilt 2002 · S/N 258592N89TBAir Med Capital LLC · Kissimmee, FLBuilt 1979 · S/N 272N900DTega Air LLC · Bend, ORBuilt 1993 · S/N 131N900KUFalcon 900-91 LLC · Lewes, DEBuilt 1991 · S/N 91N900NHNew Mfis Holdings LLC · Henderson, NVBuilt 2005 · S/N 157N900RLEib Equipment Leasing LLC · Naples, FLBuilt 2004 · S/N 131N900YPVillages Equipment Co · Leesburg, FLBuilt 2002 · S/N 114N903TBTres Borrachos LLC · Scottsdale, AZBuilt 2005 · S/N 155N904YPVillages Equipment Co · Leesburg, FLBuilt 2002 · S/N 104N908SBFalcon Hunter LLC · Houston, TXBuilt 2000 · S/N 81N90FBRegistered aircraftBuilt 2003 · S/N 258613N90WPRegistered aircraftBuilt 2004 · S/N 258692N915APAir Services Corp · Wilmington, DEBuilt 2002 · S/N 258574N917SMAircraft Fidelity Corporation Trustee · Dover, DEBuilt 1998 · S/N 099N919WTAir Waukegan LLC · Waukegan, ILBuilt 2001 · S/N 313N920EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2005 · S/N 258705N922TG100 LLC · Rancho Santa Fe, CABuilt 1999 · S/N 109N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196N929TCypress Investments LLC · Cheyenne, WYBuilt 1980 · S/N 24N931CAWild Aviation LLC · Rockford, ILBuilt 2002 · S/N 258586N942FKForty Er LLC · Bethany, OKBuilt 2001 · S/N 145N950JBKlc 158 LLC · Dallas, TXBuilt 2005 · S/N 602N955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2002 · S/N 328N979JCTamara LLC · Dover, DES/N 218N981CLHawker N981ce & N987ce LLC · Wilmington, DEBuilt 2002 · S/N 258563N984BXFarm Leasing F Inc · Atlanta, INBuilt 2004 · S/N 127N985CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 258490N987CFPeekey Lumbus LLC · Vista, CABuilt 2007 · S/N 351N987CLHawker N981ce & N987ce LLC · Wilmington, DEBuilt 2001 · S/N 258557N988AKExecutive Aircraft Sales LLC · Charlotte, NCBuilt 1987 · S/N 22N988RCMoyle Petroleum Co · Rapid City, SDBuilt 2001 · S/N 190N988RSWorldwide Option LLC · Lewes, DEBuilt 2002 · S/N 258598N991FRAudaciter LLC · Fort Lauderdale, FLBuilt 2004 · S/N 258660N994EAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N 460N999MKBig Hole Aviation LLC · Helena, MTBuilt 1982 · S/N 84N9RARoyal Air Freight Inc · Waterford, MIBuilt 1989 · S/N 651
Back to AD 2017-20-01