OpenAirDocs.org
AD 2013-22-21

Registered aircraft · 2,381

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:2013-22-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-22-21')
  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.

N20BHChemair Helicopters Inc · Jefferson, WIBuilt 1998 · S/N 53242N20TVHelicopters Inc · Linden, NJBuilt 1994 · S/N 52084N20WHGulf Helicopters LLC · Santa Fe, TXBuilt 1999 · S/N 53377N20WYKelly Sean R · Bozeman, MTBuilt 1979 · S/N 2647N20ZPatriot Aviation Inc · Greenville, DEBuilt 1982 · S/N 45334N210MHCirrus Air Express LLC · Lewes, DEBuilt 1990 · S/N 51379N210TVNexstar Media Inc · Irving, TXFirst renewal noticeBuilt 1988 · S/N 51267N211CSWithrotor Aviation Inc · Lakeview, ORS/N 2775N2122T22t Aero LLC · Hermosa Beach, CAS/N 45587N212SPAirman Helicopter Inc · Fort Lauderdale, FLBuilt 1976 · S/N 2043N213PDDrb Helicopters LLC · Klamath Falls, ORBuilt 1976 · S/N 1992N21470Southwest Heliservices LLC · Mesa, AZS/N 3467N214AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54485N21507Steuben Foods Inc · Elma, NYBuilt 1981 · S/N 3464N2150MT&M Aviation Inc · Abbeville, LABuilt 1981 · S/N 45703N2155ZHeli Incorporated · Las Vegas, NVBuilt 1981 · S/N 3476N216LSPremier Rotors LLC · St Martinville, LABuilt 1991 · S/N 51473N216MHMeridian Helicopters LLC · Broussard, LABuilt 2004 · S/N 52296N216TVDel Rio Aviation Inc · Paso Robles, CAS/N 51166N217HKHolden Thomas J · Warrington, PABuilt 1995 · S/N 4347N217JSOceanside Vertical Express LLC · Canaan, NYBuilt 1981 · S/N 3454N217MHMeridian Helicopters LLC · Broussard, LABuilt 1999 · S/N 52226N2183YRegistered aircraftBuilt 1981 · S/N 3519N2187LRanger Aviation Leasing LLC · Wilmington, DEBuilt 1981 · S/N 3497N218AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54565N218BHOsceola County Sheriffs Office · Kissimmee, FLBuilt 2006 · S/N 53704N2192Flyers Enterprises Inc · Alpine, CABuilt 1977 · S/N 2192N2193XIndustrial Helicopters LLC · Lafayette, LAS/N 3506N2196JIron Horse Cub LLC · Arlington, TXBuilt 1981 · S/N 3513N219BHOsceola County Sheriffs Office · Kissimmee, FLBuilt 2002 · S/N 53525N219HAUS Trinity Equipment LLC · Argyle, TXBuilt 2008 · S/N 53859N219RHRc Aviation Inc · Lumpkin, GABuilt 1991 · S/N 51509N219SHRegistered aircraftBuilt 1974 · S/N 1532N21BHChemair Helicopters Inc · Jefferson, WIBuilt 1998 · S/N 53262N21CLHelicopters Inc · Linden, NJBuilt 2002 · S/N 53536N21MRMacy Robert S · Post, TXBuilt 1978 · S/N 2370N21MWAir Flite Inc · Shawnee, OKBuilt 1982 · S/N 3585N21RTL&R Investment Partners LLC · Wilmington, DES/N 2659N220GPRotorheads Leasing LLC · Perham, MNBuilt 1991 · S/N 4196N220MHPremier Rotors LLC · Saint Martinville, LABuilt 1990 · S/N 51359N220SASpurger Aviation LLC · Spurger, TXBuilt 1969 · S/N 476N221GPChemair Helicopters Inc · Jefferson, WIBuilt 1994 · S/N 4309N2222LLott Jeff S · Post, TXBuilt 1998 · S/N 53306N222HAJasons Helicopter Services · New Prague, MNBuilt 1974 · S/N 1316N222LNMetro Aviation Inc · Shreveport, LAS/N 54808N2239WBodner Jessica Kay · Emigrant, MTBuilt 1969 · S/N 461N223AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 53954N223FMTexas Department Of Public Safety · Austin, TXBuilt 2026 · S/N 56477N224AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 54070N224EESutton James Donald · Turkey, NCBuilt 2004 · S/N 4576
Back to AD 2013-22-21