OpenAirDocs.org
AD 2002-22-13

Registered aircraft · 1,287

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-22-13')
    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-22-13')
  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.

N720AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7226N720XPLegacy Capital Transportation LLC · Knoxville, TNBuilt 2001 · S/N RK-315N721GChallenger Hc LLC · New York, NYBuilt 1992 · S/N 5109N723GHStarship 1 LLC · Houston, TXBuilt 1991 · S/N 5086N726PGWheless Interests LLC · Shreveport, LAS/N RK-337N726RFV-Fee Challenger 604 Aviation LLC · Whippany, NJBuilt 2000 · S/N 5451N727KBKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N RK-260N728HAHamilton Aviation Inc · Portland, ORBuilt 2025 · S/N 6229N729HZChai Trust Co LLC Trustee · Chicago, ILBuilt 2008 · S/N 5749N730BZRegistered aircraftBuilt 2002 · S/N 5531N731AWCalisports Holdings LLC · San Diego, CABuilt 2008 · S/N 5761N732PABuchalter Ventures Qof-A LLC · Montgomery, ALBuilt 2012 · S/N 5916N732WBCentral Iowa Aviation LLC · Ankeny, IABuilt 2005 · S/N RK-403N736EEAiles Dargent I LLC · Staten Island, NYBuilt 1999 · S/N 5428N736MGMilam Aviation LLC · Temple, TXBuilt 2012 · S/N 5902N747NJChallenger 601 Msn 5123 LLC · Kansas City, MOS/N 5123N749AVBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeS/N 7378N756CMZheart Aviation LLC · Fairport, NYBuilt 2008 · S/N 5728N757AVBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeS/N 7394N758CCCtb Inc · Milford, INBuilt 1997 · S/N 5353N75NPOso Fleet LLC · Jacksonville Beach, FLBuilt 2011 · S/N 5873N75RLMhi Aviation LLC · Saint Rose, LABuilt 2001 · S/N RK-312N75TGSkylink Resources LLC · Tulsa, OKBuilt 1991 · S/N RK28N760PX760px LLC · Colchester, CTBuilt 2000 · S/N 5465N765WTW W Tichenor & Co Inc · San Antonio, TXBuilt 1989 · S/N 5039N767SASlate Aircraft Company LLC · Johnstown, PABuilt 2003 · S/N 7870N7700Wilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 5745N770AVBank Of Utah Trustee · Salt Lake City, UTS/N 7130N770WWBravo Aviation LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 5177N77195Wells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7195N774CC4 C Aviation LLC · Liberal, KSBuilt 1990 · S/N RK-7N777DBCosmos Air LLC · Las Vegas, NVBuilt 2012 · S/N 5894N777GBw Aero LLC · Pleasant Valley, MOBuilt 2007 · S/N RK-540N777GUGug LLC · Doral, FLBuilt 1990 · S/N 5084N777MVAdm Prime LLC · Camden, DEBuilt 2002 · S/N 5532N778AVBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeS/N 7784N779LGBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 5621N787LG5626 Company LLC · Sarasota, FLBuilt 2005 · S/N 5626N7886Polar Bear Express II LLC · Las Vegas, NVBuilt 2003 · S/N 5559N788CGCorning Inc · Corning, NYBuilt 2009 · S/N 8104N789DCRegistered aircraftBuilt 2026 · S/N 6230N791SASlate 791 Holdings LLC · Johnstown, PABuilt 2004 · S/N 7968N793TBRedtail LLC · Oklahoma City, OKBuilt 2000 · S/N RK-285N794SBBcn Equipment LLC · Dallas, TXBuilt 2012 · S/N 5892N794SCAloft Aviation Services LLC · Spartanburg, SCBuilt 1990 · S/N 5082N798RSAriana LLC · Phoenix, AZS/N 5985N799SJAircraft Trustee Services Inc Owner Trustee · Dover, DES/N RK-467N79CGC&G Destinations LLC · Fort Lauderdale, FLBuilt 2004 · S/N 5576N79EKMcorp Air LLC · Fort Lauderdale, FLS/N RK-347N79ELEdra Lauren Leasing Corp · Cincinnati, OHBuilt 1998 · S/N RK-214
Back to AD 2002-22-13