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.

N121REHigh Life Aviation LLC · St George, UTBuilt 2017 · S/N 4636718N121SLLadet David E · Lavonia, GABuilt 1969 · S/N 27-4475N121SPFl280 LLC · Deland, FLBuilt 1960 · S/N 500B-984-25N121TDelmarva Flight Leasing Inc · East Moriches, NYBuilt 1992 · S/N 270124N121TFTorres Juan · Modesto, CABuilt 2004 · S/N 3257351N121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GABuilt 1977 · S/N 32R-7780301N121VBMt Aero LLC · Arundel, MEBuilt 2012 · S/N T18209074N1222ZFord Carol C Jr · Canyon Country, CAS/N 61-0070-129N1224TAig Aeronautics LLC · Guaynabo, PRBuilt 1999 · S/N 32-57116N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135N122JPZatika Francis · Bridgewater, NJBuilt 1978 · S/N 61P-0535227N122MENorton Mark Trustee · Stateline, NVBuilt 2000 · S/N T20608153N122TEBouchillon James R · Hanahan, SCBuilt 1972 · S/N 32-7340044N1230BM&M Modal LLC · Denver, COBuilt 2007 · S/N T18208675N1232EVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N T18208777N1232XGehrett Clifford Rooks · Sammamish, WABuilt 2007 · S/N T18208676N123ALLambert Danny J · Plainview, TXBuilt 1973 · S/N 73-32-104N123BBSingletrack Aviation LLC · Brecksville, OHBuilt 1996 · S/N 27-0220N123BEBald Moutain Aviators · Fredericktown, MOBuilt 1967 · S/N 32-40271N123GHMoyers Jeff · Troy, VABuilt 2002 · S/N T18208105N123KCHelms Brandon M · Indian Trail, NCBuilt 1976 · S/N 32R-7680431N123KW123 LLC · Allentown, PABuilt 1968 · S/N 31-198N123LMMccleary Bryan W · Marion, OHBuilt 1967 · S/N 24-4669N123PTScheller Erik G Trustee · Gig Harbor, WAS/N 31-8112020N123PVSandlapper Aviation Of De Inc · Bennington, VTBuilt 1973 · S/N 27-7305039N123RMConstruction Imports LLC · Fleetwood, NCBuilt 1996 · S/N 27-0221N123TEVirgil W Young Jr Pa · North Little Rock, ARBuilt 1994 · S/N 4622169N1243NZenisek Andrew F · Sioux Falls, SDBuilt 2006 · S/N T18208642N1247VSchwartz Mark S · Woodbury, NYBuilt 2006 · S/N T18208643N124AGPegasus Enterprises LLC · Granbury, TXBuilt 1978 · S/N 31-7852103N124EDSecond Wind Enterprises LLC · Chamblee, GABuilt 2014 · S/N 4636642N124KYMozzie Air LLC · Tampa, FLBuilt 2005 · S/N T18208453N124WABraswell Jerrold W · Dillingham, AKS/N 31-7405242N1258QSiner John R · Kingsport, TNBuilt 1999 · S/N 4636191N12595Cornell Terry Jason · Bloomsburg, PABuilt 1971 · S/N 27-4725N125AHPray Ricky Lee Trustee · Woodland Hills, UTS/N T18208240N125AKBaize Equipment LLC · Crawford, TXBuilt 2004 · S/N T18208320N125SEDyer John F · Spring, TXBuilt 1969 · S/N 61-0027N125WWRegistered aircraftBuilt 1998 · S/N 18280348N126CAFeltmann Dean A · North Charleston, SCBuilt 1974 · S/N P-257N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173N126HJPeterson Charles William · Midway City, CABuilt 1969 · S/N 24-4878N126KMVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N T18208701N126LMMatt Aviation Propertis Inc · Nashua, NHBuilt 2003 · S/N 3257336N126PCRoots & Wings Aviation LLC · West Simsbury, CTBuilt 1979 · S/N 32R-8029042N126PKPtk Equipment Inc · Miami Lakes, FLBuilt 2005 · S/N 3257390N1275RHatter Dan D · Dumas, TXBuilt 1971 · S/N 32-53N127CBird Brian A · Duluth, MNBuilt 2013 · S/N 4636604N127GT7 Golf Tango LLC · Saint Petersburg, FLBuilt 2004 · S/N 3257343N127KHCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1027-38
Back to AD 2002-17-53