AD 2011-13-03

Registered aircraft · 18,048

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:2011-13-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:2011-13-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.

N1016TPlane Fun Inc Tr Trustee · Snellville, GABuilt 2005 · S/N T18208371N1016UBlueskys Inc · Wilmington, DEBuilt 1982 · S/N 25-0727N1016XRadial Holdings LLC · Fort Worth, TXBuilt 2000 · S/N 27-0292N1017GAustin Byrum Andrew C · Rogers, ARBuilt 1981 · S/N 25-0547N1017LTop Gun Aviation Inc · Quinnesec, MIBuilt 1981 · S/N 25-0615N1017MOstroff Nathaniel S · Summerland Key, FLBuilt 1981 · S/N 25-0564N1018HGulf Air Group Inc · Crestview, FLBuilt 1980 · S/N R18201649N101AMLehs Kent · Grimes, IABuilt 2005 · S/N T18208373N101AXFogg Britt · Springdale, ARS/N P427N101BHMpdkm Inc · Las Vegas, NVBuilt 2003 · S/N 01N101CEDurocher Alain P · Long Beach, CABuilt 1982 · S/N 32R-8229066N101DHLarson David R · Boerne, TXBuilt 1960 · S/N 24-1833N101DYDyess Investments LLC · Bassfield, MSBuilt 2007 · S/N T18208674N101EEAlaskan Aerial Photography LLC · Anchorage, AKBuilt 1982 · S/N U20606602N101GKCramer Keith B · Paso Robles, CABuilt 1979 · S/N 28R-7931172N101LCReading Randall C · Redlands, CABuilt 1972 · S/N 31037N101LPGranite Boarding LLC · Loomis, CABuilt 2004 · S/N T18208265N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066N101NEDarby Flying Corp · Homestead, FLBuilt 1973 · S/N 201N101NWVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1961 · S/N 27-475N101PAKeenan Mark · Chico, CAFirst renewal noticeBuilt 1979 · S/N EA-39N101PLHay William G Jr · Gualala, CAS/N 27-7754156N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062N101TVSky Helicopters Inc · Garland, TXBuilt 1998 · S/N 0475N101UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 250631N101WCRamey Curtis · Hilton Head Island, SCBuilt 1976 · S/N 32R-7680381N101YBCowan Lance E · Watonga, OKBuilt 1969 · S/N 31-406N101YTJagt Terrence L · Crestline, CABuilt 1973 · S/N 28-7310080N1021PYurok Tribe Construction Corp · Klamath, CABuilt 2005 · S/N T18208383N1023XBickley David R · Pocatello, IDBuilt 1975 · S/N 28-7510074N1024LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N P-78N10262Davoli Third Family Limited Partnership · Lighthouse Point, FLFirst renewal noticeBuilt 2006 · S/N T18208495N1026CMooney Howard James Jr · Lake Wales, FLBuilt 1995 · S/N 27-0203N1026UMooneylust LLC · Springfield, MOBuilt 1989 · S/N 25-1215N1027FFilarski Darryl M · Grosse Ile, MIBuilt 1971 · S/N 32-7140036N1028GCreed Brian H · Fredericksburg, VABuilt 2005 · S/N T18208381N1028RGarner Donald G · Greeley, COBuilt 1980 · S/N P210-00401N1029TThomson Heath · Portola Valley, CABuilt 1999 · S/N T20608067N1029XBaden Frederick Richard · Mc Arthur, OHBuilt 1975 · S/N 32-7540181N102DLP & G Trading Co Inc · Trenton, NJBuilt 1994 · S/N EA-567N102EASteves Atv Services Inc · Oceano, CABuilt 1976 · S/N 32R-7680158N102JFAble Enterprise LLC · Tampa, FLBuilt 2006 · S/N T18208579N102KYPatriot Aviation LLC · Rostraver Township, PABuilt 1978 · S/N P21000093N102TMJunior Fernando Sporleder · Sarasota, FLBuilt 1976 · S/N 31-7712015N102WCDac 2020 Inc · Skaneateles, NYBuilt 1978 · S/N 340A0443N102WHStuddiford James A · Lithia, FLS/N 31-7952066N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112N1030ZLenhart Thomas E · Barnesville, GABuilt 1997 · S/N 23041CN1031RKeller Paul M · Sanford, NCBuilt 1989 · S/N 25-1216
Back to AD 2011-13-03