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.

N5069CMugleston Tim H · Waldport, ORS/N D-2331N5071CWalker Rhan E · Pleasant Hill, MOBuilt 1950 · S/N D-2333N5074CJ & S Aviation LLC · Scottsdale, AZS/N D-2336N5076CPrecision Design Inc · Weatherford, OKS/N D-2338N5077CStack And Associates LLC · Coral Springs, FLS/N D-2380N5079COwens Robert B · Bryan, TXBuilt 1950 · S/N D-2341N5081CWagner Dixie Lee · Roswell, NMBuilt 1950 · S/N D-2343N5082CJohnson Gregory J · Port Orange, FLBuilt 1950 · S/N D-2344N5084CStalnecker William H · Lebanon, PABuilt 1950 · S/N D-2346N5100CClefton Gordon A · New Creek, WVBuilt 1950 · S/N D-2362N5105CColston David T · Vero Beach, FLS/N D-2386N5108CLee Brandon Thomas · Pace, FLBuilt 1950 · S/N D-2389N5109CCurry Demetrius · Kansas City, MOS/N D-2387N5112CDelaware Aircraft Trust LLC Trustee · New Castle, DES/N D-2395N5117CPerazzo Enterprises Inc · Brookeland, TXS/N D-2402N5118CHammill Michael R · Alamance, NCS/N D-2403N5124CKansas Aviation Museum · Wichita, KSBuilt 1950 · S/N D-2409N5126CUlmer Eric R · StockholmBuilt 1950 · S/N D-2411N5130CGuy Jeffrey · Centerburg, OHBuilt 1950 · S/N D-2415N5135CPogorelec Michael · Beaver Dam, WIS/N D-2420N5137CSandegren Lars F · Lake Saint Louis, MOBuilt 1950 · S/N D-2422N5138CBean Bonnie J · Surprise, AZS/N D-2423N5139CTorkelson Charles A · San Antonio, TXBuilt 1950 · S/N D-2424N5140CGeantil Thomas G · San Diego, CABuilt 1950 · S/N D-2425N5145CWard Austin L · Kokomo, INBuilt 1950 · S/N D-2430N5158CSmith Edward I · Suffolk, VABuilt 1950 · S/N D-2443N5159CAircraft Partner Holdings Inc Trustee · BerlinS/N D-2444N515BTurnkey Design Build LLC · Sarasota, FLFirst renewal noticeBuilt 1948 · S/N D-1539N5160CCollins Robert E · Belleville, ILBuilt 1950 · S/N D-2445N5165CHuskey James R · Guthrie, OKBuilt 1950 · S/N D-2450N5170CMcgrath Patrick G · Auburn, KSBuilt 1950 · S/N D-2455N5171CGump Check LLC · New Port Richey, FLBuilt 1950 · S/N D-2456N5174CHamlin Jeffry S · Double Oak, TXBuilt 1950 · S/N D-2585N5175CW Graber Contracting LLC · Amboy, INBuilt 1950 · S/N D-2400N5178CReid Brian S · Merced, CABuilt 1950 · S/N D-2460N5186CGreiman George M · Garner, IABuilt 1950 · S/N D-2468N5188CMagnuson Waldo G Jr · Spokane, WABuilt 1950 · S/N D-2470N5191CWeeks Benjamin D · Highlandville, MOBuilt 1950 · S/N D-2473N5196CBurnham Kenneth J · Carr, COS/N D-2478N5198CR & S Enterprises · Fort Wayne, INBuilt 1950 · S/N D-2480N5199CWhisanant Bob · Winnett, MTBuilt 1950 · S/N D-2481N5202CJames Joe T · Brownsville, ORBuilt 1950 · S/N D-2547N5203CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1950 · S/N D-2548N5204CPeace Sign LLC · Bozeman, MTBuilt 1950 · S/N D-2549N5206COnderdonk William A III · Spring Branch, TXBuilt 1950 · S/N D-2551N5216CGusset LLC · Omaha, NEBuilt 1950 · S/N D-2561N5218CMikesell Tim · Decatur, ILBuilt 1950 · S/N D-2563N5220CD & A Aviation LLC · Melbourne, FLBuilt 1950 · S/N D-2565N5226CShaner Toby D · Burlington, WABuilt 1950 · S/N D-2571N5239CDewitt Frederick E · Sycamore, ILS/N D-2630
Back to AD 2002-21-13