AD 2002-20-09

Registered aircraft · 1,548

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-20-09')
    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-20-09')
  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.

N121VMAlan Aviation LLC · Altadena, CAS/N 525-0314N1220WP2 Flight Operations LLC · Fort Worth, TXBuilt 2003 · S/N 525A0146N122DSDiamond A Aviation LLC · Amarillo, TXS/N RB-100N122KHAirric LLC · Miromar Lakes, FLBuilt 2003 · S/N 525A0159N123EDFrench Fly LLC · San Jose, CAS/N 258366N124BGAdvance Jets LLC · Cincinnati, OHBuilt 1999 · S/N 525-0345N124HMiss Juliet LLC · Chatsworth, GABuilt 2002 · S/N 525A-0068N125BJQualitair LLC Trustee · MichelstadtS/N 525A0101N125DWMcis Aviation LLC · Wilmington, DEBuilt 2021 · S/N 525-1095N125XPN125xp LLC · Wilmington, DEBuilt 2000 · S/N 258485N1277EHeaven Express LLC · Corralitos, CABuilt 2002 · S/N 525A0076N127FJFoxtrot Juliette Assets LLC · Newark, DEBuilt 2009 · S/N 525A0441N127MJZacj LLC · Zanesville, OHBuilt 1998 · S/N 525-0266N12GYValiair Limited Co Trustee · Casper, WYBuilt 2000 · S/N 525-0374N12NSCbi Equipment LLC · Tualatin, ORS/N 525-1063N12RLPumpkin Patch Aviation LLC · Kodak, TNBuilt 2026 · S/N 525-1409N130YBMwl Aviation 1 LLC · Miami Lakes, FLBuilt 2002 · S/N 258590N131PLPd Aero LLC · Oronogo, MOBuilt 1994 · S/N 525-0057N1327JAbsolute Altitude LLC · Bellefontaine, OHBuilt 1993 · S/N 525-0009N133GLHs Air LLC · Little Rock, ARBuilt 1993 · S/N 525-0001N133KSJyh Aviation LLC · Jacksonville, FLBuilt 2004 · S/N 258697N134CJSkyview LLC · Wilmington, DES/N 134N134SWSugar Woods Family Aviation LLC · Shreveport, LAS/N RB-81N136MVTransnet Aviation Group LLC · Short Hills, NJBuilt 2001 · S/N 311N138SJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N RB-138N140DARamsey Hill Aviation LLC · River Falls, WIBuilt 2003 · S/N 525A0140N1414PWest Texas Pcs LLC · Los Ranchos, NMBuilt 2006 · S/N 525A0315N143QCKeystone Senior Ac LLC · North Miami, FLBuilt 2004 · S/N RB-114N144YDZellair LLC · Wilmington, DEBuilt 2003 · S/N 525A0144N145JSWms Aviation LLC · Las Vegas, NVS/N RB-119N146MMJackdaw Inc Trustee · Wilmington, DEBuilt 1997 · S/N 5250226N146SMTurbo Air Charter LLC · Boise, IDBuilt 2003 · S/N 525A0154N1482BClear Line Aviation LLC · St George, UTBuilt 2015 · S/N 525-0888N148FBTelum Air LLC · Sioux Falls, SDBuilt 2003 · S/N 525A0148N14PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 258317N150JMPog Capital LLC · Wilmington, DEBuilt 1998 · S/N 258382N150RJ513 LLC · Newark, DEBuilt 2002 · S/N 324N152KVPlane House LLC · Indianapolis, INBuilt 1996 · S/N 525-0152N153CJAbbey Air Inc · Birmingham, ALBuilt 2003 · S/N 525A0153N153TJDavis Air LLC · Vero Beach, FLBuilt 2007 · S/N 525A0377N154RRN154rr LLC · Wilmington, DEBuilt 1998 · S/N 258375N155BWPoet Inc · Sioux Falls, SDBuilt 2018 · S/N 525-0988N155CGBigees Air LLC · Sioux Falls, SDBuilt 1997 · S/N 525-0214N156MLAir Miles LLC · River Falls, WIBuilt 1996 · S/N 525-0156N156NSNunya LLC · Costa Mesa, CABuilt 2004 · S/N 258668N159FMC&K Air LLC · New Castle, DEBuilt 2003 · S/N 258651N15EDClearview Aviation Group LLC · Peachtree City, GABuilt 2015 · S/N 525-0855N15RKPlane Part Solutions LLC · Lake Park, FLBuilt 1996 · S/N 258297N15WEFirstrike Aviation LLC · Tulsa, OKBuilt 2014 · S/N 525-0847N15YDN15yd LLC · Lewes, DES/N 525A0336
Back to AD 2002-20-09