OpenAirDocs.org
AD 2002-21-13

Registered aircraft · 579

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-21-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-21-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.

N2824VBigfoot Aviation LLC · Saint Michael, MNBuilt 1947 · S/N D-228N2834VKieper Mark A · Hampton, MNBuilt 1947 · S/N D-239N2846VRegistration Pending · Shawnee, OKRegistration pendingS/N D-251N2855VBunka Donald P · Fenton, MIBuilt 1947 · S/N D-260N2858VMyers Alyssa L · Clayton, NMS/N D-263N2860VNord Aviation Inc · Pembina, NDBuilt 1947 · S/N D-265N2861VBeck Roger M Trustee · Goode, VABuilt 1947 · S/N D-266N2868VBiehle Michael A · Yuba City, CAFirst renewal noticeBuilt 1947 · S/N D-273N2870VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N D-275N2896VKenyon Joseph S · Fort Collins, COS/N D-304N2897DMiller Earl R · Gig Harbor, WABuilt 1947 · S/N D-898N2897VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N D-305N2899VMtv Aero Group · Pauls Valley, OKS/N D-307N2923CColley Robert E · Jamestown, TNBuilt 1955 · S/N D-310N2927VHereth Eric W · El Cajon, CAS/N D-311N2929VEllis Donald D W · High Springs, FLBuilt 1947 · S/N D-313N2941VDowns Roland · Oro Valley, AZBuilt 1947 · S/N D-329R12N2975VBuckalew James E · Kingsville, TXBuilt 1947 · S/N D-371N2976VDolby Kevin L · El Paso, TXFirst renewal noticeBuilt 1947 · S/N D-372N2979VZxtair LLC · Mankato, MNBuilt 1947 · S/N D-376N2983VBellgardt Robert · North Bend, WABuilt 1947 · S/N D-380N2987BKrog Donald C · Somerville, NJBuilt 1953 · S/N D-3625N2989VContessa Holdings Ltd · Cheyenne, WYS/N D-386N2991VParsons Franklin R Jr Trustee · Kiowa, COS/N D-389N2992VSheridan Jeffrey S · Lakeville, MNBuilt 1947 · S/N D-390N2994VJetmx Inc · Goodyear, AZS/N D-392N2997VMcmahon Jeffrey J · Paris, KYFirst renewal noticeBuilt 1947 · S/N D-396N2TDRds LLC · Strongsville, OHBuilt 1949 · S/N D-2004N3001VHillier David C · Oakdale, CABuilt 1947 · S/N D-400N3013VCusick Christopher J · La Jolla, CABuilt 1947 · S/N D-415N3019VTimmons Mark M · New Port Richey, FLBuilt 1947 · S/N D-423N3021VMunoz Pedro L · Ontario, NYBuilt 1947 · S/N D-425N3041VGood Brian L · Wildomar, CABuilt 1947 · S/N D-448N3056VMinneman Alan R · Jefferson, TXBuilt 1947 · S/N D-469N3061VRegistration Pending · Amboy, INRegistration pending, pending cancellationBuilt 1947 · S/N D-474N3064VLehmann Mark C · Trade, TNS/N D-478N3065VEvans Bruce E · Aztec, NMBuilt 1947 · S/N D-479N3068VBurgin Lee · Borger, TXS/N D-482N3074VHancock Steven W M · Bristow, VABuilt 1947 · S/N D-488N3083VAnderson Charles E · Fort Worth, TXBuilt 1947 · S/N D-498N3088VStartz John D · Dallas, TXBuilt 1947 · S/N D-504N3089VMaximus Aviation LLC · Cheyenne, WYBuilt 1947 · S/N D-505N3093VBeavers Charles M · Rockmart, GABuilt 1947 · S/N D-510N3096VNovak Warren Devereaux Grey · Lake Placid, FLBuilt 1947 · S/N D-513N30EBowker Mark S · Bowdoinham, MES/N D-2475N3101VWallace William D · Brunswick, GABuilt 1947 · S/N D-520N3111VStewart Ladd E · Augusta, KSBuilt 1947 · S/N D-533N3113VMurrell Louis B · Wichita, KSS/N D-535R6N3114VWheeler Jack W · Greensboro, NCBuilt 1947 · S/N D-536N3119VMartin Lynn E · Princeton, TXBuilt 1947 · S/N D-543
Back to AD 2002-21-13