AD 2002-14-19

Registered aircraft · 2,057

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

N128ASParker Robert E · Corpus Christi, TXS/N BB-1950N128VTState Of Missouri · Jefferson City, MOBuilt 1992 · S/N BB-1442N129EMAdams Aviation Services Inc Trustee · Wilmington, DES/N UE-229N129TNGuardian Flight LLC · Lewisville, TXBuilt 2005 · S/N LJ-1742N130BDBank Of Utah Trustee · Salt Lake City, UTS/N FL-922N131BLLta Group Holdings LLC · Amarillo, TXBuilt 2001 · S/N LJ-1654N131KGKa131kg LLC · Knoxville, TNBuilt 2018 · S/N FL-1131N132KCAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-132N132NFlying Cowboys LLC · Merced, CAS/N BB-1053N133GAJab Aire LLC · Wilmington, DEBuilt 1989 · S/N BB1321N1344LU S Army · Redstone Arsenal, ALBuilt 2024 · S/N FL-1344N1346KU S Army · Redstone Arsenal, ALBuilt 2025 · S/N FL-1346N1349KU S Army · Redstone Arsenal, ALBuilt 2025 · S/N FL-1349N134CJSkyview LLC · Wilmington, DES/N 134N134ECFly Invest Inc Trustee · Wilmington, DEBuilt 2008 · S/N 1160N134JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 1134N1351KU S Army · Redstone Arsenal, ALBuilt 2025 · S/N FL-1351N1357KTextron Aviation Inc · Wichita, KSBuilt 2025 · S/N FL-1357N135AAKentucky King Air LLC · Hazard, KYBuilt 1985 · S/N LJ-1112N136JXCpjv LLC · Greenville, SCBuilt 1998 · S/N 136N136KFFisher Auto Parts Inc · Staunton, VABuilt 2016 · S/N FL-1036N136MVTransnet Aviation Group LLC · Short Hills, NJBuilt 2001 · S/N 311N137FLCharlie-001 LLC · Sugar Grove, ILBuilt 1996 · S/N FL137N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753N140MCPlane To Sea LLC · Raleigh, NCBuilt 1996 · S/N FL-140N141LVictor One Four One LLC · Boston, MABuilt 2007 · S/N FL-524N141SULynch Family Companies Inc · Waucoma, IABuilt 2022 · S/N FL-1308N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49N1459General Atomics Aeronautical Systems Inc · San Diego, CABuilt 2009 · S/N FL-667N145AFDale Aviation Inc · Rapid City, SDS/N LJ-1721N145SLCash Depot Ltd · Green Bay, WIBuilt 2004 · S/N 1093N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046N146SLDodson International Parts Inc · Rantoul, KSS/N 1091N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276N14TURegan Aviation LLC · Stateline, NVBuilt 1993 · S/N 026N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531N150GXWest Penn Aviation LLC · Midland, TXBuilt 2008 · S/N FL592N150RFR & F Wings III LLC · Liverpool, NYBuilt 2015 · S/N FL-1023N150RJ513 LLC · Newark, DEBuilt 2002 · S/N 324N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151N152URoyal Air Inc · Shreveport, LABuilt 1968 · S/N P-14N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153
Back to AD 2002-14-19