AD 2002-17-53

Registered aircraft · 6,266

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:2002-17-53')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-17-53')
  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.

N134JFFlamingo Ridge Aviation LLC · Interlachen, FLBuilt 1993 · S/N 27-0150N134KAHgj Capital Holdings LLC · Newark, DEBuilt 2007 · S/N T18208671N134STBetancourt Ramses · Key West, FLBuilt 2006 · S/N 4692038N134TSDobalian Vaughn E · Jacksonville Beach, FLBuilt 1973 · S/N 61-0134-072N1355TRmf Trucking LLC · Tuscaloosa, ALBuilt 1972 · S/N 32-7240115N135GVreeland Equipment Rental LLC · Dayton, OHBuilt 1999 · S/N T20608077N135PDFerreira Mario M · New Bedford, MAS/N A-825N135RJKontz Gary Lee · Canby, MNBuilt 1967 · S/N 31-52N135TRTrue Equipment Leasing LLC · Bozeman, MTBuilt 2011 · S/N T18209039N135TSN135ts LLC · Lima, OHBuilt 2003 · S/N T20608413N135TWValiair Lc Trustee · Casper, WYS/N 31-7852001N13760Chiniewicz Michael · The Colony, TXBuilt 1969 · S/N 27-4409N137CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N T18209143N137HPCalifornia Highway Patrol · Sacramento, CABuilt 2015 · S/N GA8-TC 320-15-218N137JHFlatspin LLC · Belle Chasse, LABuilt 1981 · S/N 31-8252025N137TSArk Aviation LLC · Moncks Corner, SCBuilt 2003 · S/N T20608415N13803Crociati Douglas R · Plymouth, MABuilt 1969 · S/N 27-4448N13817Conroy Philip L DBA · Colleyville, TXBuilt 1969 · S/N 27-4462N13832Davey Spencer J · Spokane, WAS/N 27-4474N13839Tyler Petroleum Inc · Tyler, TXBuilt 1970 · S/N 27-4480N13862Reliance Island Inc · Wilmington, DEBuilt 1970 · S/N 27-4500N13865Enzed Aviation Services LLC · Anchorage, AKS/N 27-4503N13882Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1970 · S/N 27-4517N1389BColumbia Safety Medical LLC · Kennewick, WABuilt 2005 · S/N T18208455N138AZTablemax Aeronautics LLC · El Paso, TXBuilt 2004 · S/N T18208355N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935N13901Masscotte Michael · Mansfield, MABuilt 1970 · S/N 27-4533N1391AAqua Aviation LLC · Danville, CABuilt 2007 · S/N T18208723N1391TAbita Air LLC · Covington, LABuilt 1972 · S/N 32-7240117N13950Bml Aviation LLC · Arvada, COBuilt 1970 · S/N 27-4567N13980Aileron Buzz LLC · Daytona Beach, FLBuilt 1970 · S/N 27-4598N13982Bray Aviation LLC · Calera, OKBuilt 1970 · S/N 27-4600N13984Smith Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeBuilt 1970 · S/N 27-4602N13987Island Birds Inc · St Thomas, VIBuilt 1971 · S/N 27-4605N13998Granger Vic · Union Grove, ALS/N 27-4616N139CASquires Gregory K · Cedar Park, TXBuilt 1966 · S/N 24-4570N139HPCalifornia Highway Patrol · Sacramento, CABuilt 2015 · S/N GA8-TC-320-15-224N139LFLgd Properties Inc · Wylie, TXBuilt 2011 · S/N 4636505N139WTCotton Business Enterprises LLC · Hummelstown, PABuilt 2000 · S/N 27-0283N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411N13CEWilley R Scott · Layton, UTBuilt 1970 · S/N 31007N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046N13JBAltitude Aviation Services LLC · Mountain Home, IDBuilt 1976 · S/N 61P-0323-090N13NEQualitair LLC Trustee · MichelstadtBuilt 1984 · S/N 31P-8414035N13RZBjornstad Eugene N Trustee · Girdwood, AKBuilt 1989 · S/N 570N13TTKlcc Holdings LLC · Boca Raton, FLS/N 27-7554069N14005Delaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-4623N14012Rock Valley College · Rockford, ILBuilt 1971 · S/N 27-4629N14028Stoks Derek R · Canby, MNS/N 27-4689
Back to AD 2002-17-53