AD 2002-19-03

Registered aircraft · 12,723

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-19-03')
    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-19-03')
  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.

N101WCole-Tac LLC · Rapid City, SDBuilt 1980 · S/N 32R-8013087N101WCRamey Curtis · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680381N101WGGard Aviation LLC · Elkhart, IABuilt 2009 · S/N 40697N101YBCowan Lance E · Watonga, OKBuilt 1969 · S/N 31-406N1021PYurok Tribe Construction Corp · Klamath, CABuilt 2005 · S/N T18208383N1024NSolomon Jeremy M · Somerset, NJBuilt 2012 · S/N 3 FX026N1025NGood Aviation LLC · Oshkosh, WIBuilt 1996 · S/N 23026CN10262Davoli Third Family Limited Partnership · Lighthouse Point, FLFirst renewal noticeBuilt 2006 · S/N T18208495N1026CMooney Howard James Jr · Lake Wales, FLBuilt 1995 · S/N 27-0203N1027FFilarski Darryl M · Grosse Ile, MIBuilt 1971 · S/N 32-7140036N1028GCreed Brian H · Fredericksburg, VABuilt 2005 · S/N T18208381N1029TThomson Heath · Portola Valley, CABuilt 1999 · S/N T20608067N1029XBaden Frederick Richard · Mc Arthur, OHBuilt 1975 · S/N 32-7540181N102AKRegistered aircraftBuilt 2006 · S/N 20608264N102BROtv Leasing · Bristow, VAFirst renewal noticeBuilt 2010 · S/N 18282264N102EASteves Atv Services Inc · Oceano, CABuilt 1976 · S/N 32R-7680158N102FMRegistered aircraftBuilt 2015 · S/N 001N102KTPoler Steven P · Olympia, WABuilt 2014 · S/N 41059N102LPWashington State Patrol · Olympia, WABuilt 2002 · S/N 18281121N102MASquaw Creek Aviation LLC · Dover, DES/N 18280100N102MREquipment Services Corp · Wahpeton, NDS/N 30020CN102TMJunior Fernando Sporleder · Sarasota, FLBuilt 1976 · S/N 31-7712015N102WHStuddiford James A · Lithia, FLS/N 31-7952066N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112N1030NDcaw Aviation LLC · Advance, NCBuilt 2006 · S/N 3246242N1031XJj Byrne International Inc · Steamboat Springs, COS/N T18208268N1033CHuson Lee E · Port Townsend, WABuilt 1997 · S/N 25012CN1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135N1036XMotley Douglas Trustee · Rehoboth Beach, DEBuilt 1975 · S/N 32-7540131N1039PN1039p LLC · Suwanee, GABuilt 2005 · S/N 18281566N103ARHd Outdoor Advs LLC · Coalgate, OKBuilt 2005 · S/N 18281663N103ATWjm Aviation LLC · Bridgeville, PABuilt 1970 · S/N 32-40951N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202N103DJChicoine Chris · Williston, VTS/N 50N103EAJwp Group LLC · Long Island, MEBuilt 1976 · S/N 32R7780054N103ENKjs Development LLC · Temecula, CABuilt 1995 · S/N 4622186N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153N103MRDeepvine Partners LLC · Simonton, TXBuilt 2004 · S/N T20608455N103NCState Of North Carolina · Raleigh, NCBuilt 1999 · S/N 18280647N103PZRaging Thermal Sky Sports LLC · Brighton, COBuilt 2005 · S/N 25102CN103RRLancaster Flyers LLC · Fenwick Island, DEBuilt 1979 · S/N 32-7940097N103SJBarnick Air Holdings LLC · Santa Barbara, CABuilt 2000 · S/N 20608101N103TXWilliams Bradley H Jr · Charleston, SCBuilt 2001 · S/N 18280984N103URankin Kenneth · Pinellas Park, FLBuilt 1986 · S/N 585N1040ZDonnelly Jeff E · Pembroke, MABuilt 2006 · S/N 3232062N1041CHelzer Timothy · Tucson, AZBuilt 2003 · S/N 270321N1041HCentury Flight Systems Inc · Mineral Wells, TXBuilt 1977 · S/N 32R-7780125N1044LFitch Mark · Anchorage, AKBuilt 1996 · S/N 25009C
Back to AD 2002-19-03