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.

N8639ARegistration Pending · Sparta, MORegistration pending, pending cancellationBuilt 1949 · S/N D-2049N8642AKrulic Charlie Bartol III · Greenville, SCBuilt 1949 · S/N D-2052N8652AGnb Aviation LLC · Lake City, TNBuilt 1949 · S/N D-2062N8654APicturesque Aviation LLC · Fort Worth, TXBuilt 1949 · S/N D-2064N8657APierson Jeffrey L · Montague, MIBuilt 1949 · S/N D-2067N8659ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1949 · S/N D-2069N8662AAircraft Partner Holdings Inc Trustee · BerlinS/N D-2127N8667AForthun Daniel Jay · Argyle, TXS/N D2129N8669ARounds Chris · Waller, TXBuilt 1949 · S/N D-2079N8681ACopeland Forrest H · Brentwood, CABuilt 1949 · S/N D-2091N8692ACrouse Wayne A · Bernice, OKBuilt 1949 · S/N D-2200N8700AJurskis Joseph S · Darien, GABuilt 1949 · S/N D-2110N8708AMcilvenna John · Chandler, AZS/N D-2118N8718AMcnutt Brian K · Dillon, MTBuilt 1949 · S/N D-2245N8721AHoffman Kevin · Chatsworth, GAS/N D-2248N8724AMoncks Corner Flyers LLC · Moncks Corner, SCBuilt 1950 · S/N D-2251N8724RShewalter Nicholas · Frankfort, MIBuilt 1950 · S/N D-2650N8725AApostolico Richard D · Charleston, SCS/N D-2364N8727ACossairt Keith L · Elk Grove, CABuilt 1949 · S/N D-2149N8729ASpivey Kenneth R Jr · Vestavia, ALBuilt 1949 · S/N D-2151N8733AArmstrong Craig V · Casstown, OHFirst renewal noticeBuilt 1949 · S/N D-2155N8735ARhoades Randal W · Newcastle, WYBuilt 1949 · S/N D-2157N8738AErickson Jacob · Graham, WAS/N D-2160N8766ABowden David A · Duncan, OKBuilt 1950 · S/N D-2202N87813Spence Michael D · Ruidoso, NMBuilt 1947 · S/N D-122R-14N8781AFischer Dan · Houston, TXBuilt 1949 · S/N D-2186N8783AScott Roland E Jr · Baltimore, MDS/N D-2205N8786ABloch Eden R · Riverside, CABuilt 1950 · S/N D-2208N8787AGehling Kelly P · Fort Worth, TXBuilt 1950 · S/N D-2209N8789ASafrit Christopher · Midlothian, TXBuilt 1950 · S/N D-2211N8794AFramiglio John · Nashville, TNBuilt 1950 · S/N D-2216N8796AGregory Edward G Jr · Sparks, NVBuilt 1950 · S/N D-2218N8800ABarnes Richard E · Malin, ORBuilt 1950 · S/N D-2222N8810ACovert Aero LLC · Warren, VTBuilt 1950 · S/N D-2232N8813ALange Eric M · Prescott, AZBuilt 1950 · S/N D-2257N8815AMoore Steven L · Glasgow, KYBuilt 1950 · S/N D-2259N8818RCrawford Brian L · Surprise, AZFirst renewal noticeS/N D-2397N8819ARegistered aircraftBuilt 1950 · S/N D-2235N8822ASellers Ronald C · Knoxville, TNBuilt 1950 · S/N D-2367N8826AKirkpatrick Robert Allan · Placerville, CABuilt 1950 · S/N D-2371N8830ACansler Seth A · Greenville, TXBuilt 1950 · S/N D-2484N8831ALyons James P · Lake Suzy, FLBuilt 1950 · S/N D-2485N8837AFrisbie Anthony G · Dallas, TXBuilt 1950 · S/N D-2492N8839ALove Robert W · King George, VABuilt 1950 · S/N D-2494N8846AJolliff Travis L · El Paso, TXBuilt 1950 · S/N D-2501N884DBMessiah Angel LLC · Pennsauken, NJBuilt 1949 · S/N D1600N8850AGibson Lawrence D · Lakeland, FLBuilt 1950 · S/N D-2505N8857ADixon Kevin S · Denton, TXS/N D-2512N8858ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1950 · S/N D-2513N8860AWilmoth Todd · Keystone Heights, FLBuilt 1950 · S/N D-2515
Back to AD 2002-21-13