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.

N1285ROrbit Aviation LLC · Lakewood, CAS/N 31026N1287TBelle Casa Aero LLC · Tarpon Springs, FLBuilt 1972 · S/N 32-7240111N128AGarza Family LLC · Helena, MTBuilt 1967 · S/N 32-40354N128EDSimply Living LLC · Fort Myers, FLBuilt 2000 · S/N 4636258N128HBSowle LLC · Tampa, FLBuilt 2007 · S/N 3257479N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074N128WPPatterson Weldon E · Maryville, TNBuilt 1969 · S/N 32-40579N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112N129BBLawson Michael · Englewood, TNBuilt 1969 · S/N 31-481N129MBYellowfin Air Services LLC · Wilmington, DEBuilt 1971 · S/N 3108N129RCAirris Aviation & Marine Co · N Fort Myers, FLBuilt 1993 · S/N 27-0173N12BHMunk-Ee Business Aviation LLC · Linden, MIBuilt 1956 · S/N 157-195N12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1974 · S/N 27-7405422N12KWAllied Moulded Products Inc · Bryan, OHBuilt 2000 · S/N 4636255N12LVR2b2 Enterprises Lllp · Weldon Spring, MOBuilt 1975 · S/N 61-0238-099N12STWise Ventures LLC · Mooresville, NCBuilt 2006 · S/N 3257412N12TZJ H O Enterprises Inc · Carol Stream, ILS/N 61-0259-101N12WZNortech Data Services Inc · Wilmington, DEBuilt 2003 · S/N 2206N12XLAurora Aviation LLC · Billings, MTBuilt 2004 · S/N 27-0325N130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N T20608130N130XRM&A Adams Family Lp · Mckinney, TXS/N 32R-7887003N1315BN1315b Aviation LLC · Wilmington, DEBuilt 2002 · S/N T18208147N131DLEscondido Aviation LLC · Marfa, TXBuilt 2007 · S/N T18208717N131FAJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 27-4097N131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030N131RLLeads Air Inc · Dover, DEBuilt 1989 · S/N 4622048N131TPremiere Aircraft LLC · Dover, DEBuilt 2009 · S/N 4692103N131TVO'Brien Daniel H · Half Moon Bay, CABuilt 1977 · S/N 27-7754070N1322YAlcyone Trust Corp Trustee · Wichita, KSBuilt 2008 · S/N T18208811N1322ZInternational Realty Group LLC · Bakersfield, CABuilt 2024 · S/N T18209134N1323NJohnston Jeffrey Heath · Midland, TXBuilt 2006 · S/N T18208665N13259Nuthatch Air Services LLC · New York, NYBuilt 2006 · S/N T18208663N1325DMontero Carlos · San Lorenzo, CABuilt 2006 · S/N T18208658N1325YDuty First Holdings LLC · Wichita, KSBuilt 2006 · S/N T18208660N1327TCedel Solutions LLC · Austin, TXBuilt 1972 · S/N 32-7240113N1328NFirst Agri Inc · Sudan, TXBuilt 2005 · S/N T18208403N1329DHewitson Enterprises Inc · Avenal, CABuilt 2006 · S/N T18208664N132CHSimon Aviation LLC · Bourg, LABuilt 1978 · S/N 32R-7887060N132DRAasap Construction Co Inc · Conway, SCBuilt 1980 · S/N 32R-8029108N132GMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 3257335N132GTLegal Eagle 2 LLC · Jefferson City, MOBuilt 2007 · S/N 3257447N132LTCobblestone Capital Aviation LLC · Sylacauga, ALBuilt 2011 · S/N 4636493N133CTValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-7912118N133DR814ma Inc · Van Alstyne, TXBuilt 2005 · S/N 3255027N133KBIsland Time Aviation LLC · Peachtree City, GABuilt 1996 · S/N 4636049N133PRJamian Corporation · Lewes, DEBuilt 1993 · S/N 27-0157N133WCRegistration Pending · Huntingdon, TNRegistration pendingBuilt 2000 · S/N 4636251N1343TWestern Cherokee Six LLC · Fort Collins, COBuilt 1972 · S/N 32-7240114N134CHTeke Elevate LLC · San Antonio, TXBuilt 1978 · S/N 32R-7887138N134GWFord Matthew L · Clayton, GABuilt 2002 · S/N T18208134
Back to AD 2002-17-53