OpenAirDocs.org
AD 47-21-13

Registered aircraft · 126

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:47-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:47-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.

N10198Coonfield Russell A · Fayetteville, ARS/N 603N12CXHinds Bruce R · Port Orchard, WABuilt 1947 · S/N 264N12XEMacleod Edward N · Trenton, MEBuilt 1947 · S/N 1059N191VMcgregor Carter III · Wichita Falls, TXBuilt 1946 · S/N 150N20CBHayes Jack D · Kingman, AZBuilt 1947 · S/N 522N217GHoag Tom E · Bellevue, WABuilt 1947 · S/N 797N230FKings Wings LLC · Elkton, VAS/N 519N27CBHuey Andrew G · Fulton, MOBuilt 1947 · S/N 262N295CBMurphy Patrick W · Orange City, FLBuilt 1947 · S/N 912N2TBWhalen Shenandoah · Amelia, OHBuilt 1947 · S/N 819N32264Congdon Robert E · Anchorage, AKBuilt 1946 · S/N 248SSN3263GMadden Russell · Graford, TXBuilt 1947 · S/N 361N328CBThorne Matthew L · Vicksburg, MIS/N 940N33CSMtas LLC · Laveen, AZS/N 994N451EMensing Roger G · Sarasota, FLBuilt 1946 · S/N 182N451ZAlquist Kevin B · Edwardsville, KSBuilt 1947 · S/N 584N463RKKaskel Super Service LLC · Evansville, INBuilt 1947 · S/N 958N5090JAttitude Toys LLC · Wilmington, DEBuilt 1946 · S/N 244N5166BHublou Frank E · Carson City, NVBuilt 1947 · S/N 1000N5989MJohnson Dean M · Hamden, CTBuilt 1947 · S/N 387N5YLBold William H Jr · Annapolis, MDBuilt 1947 · S/N 330N6007KPark Richard A · Alameda, CABuilt 1946 · S/N 177N6041KLudmerer Victor J · Greenwood Lake, NYBuilt 1946 · S/N 216N6047KMummy Mountain Med LLC · Paradise Valley, AZS/N 222N6048KWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1947 · S/N 223N6072KWeiss Elliott · Fresno, TXBuilt 1947 · S/N 252N6102KSes Bee LLC · Appleton, WIBuilt 1947 · S/N 285N6113KRegistered aircraftS/N 296N6118KAllen Richard P · Southampton, NJBuilt 1947 · S/N 301N6124KLacy Clay Trustee · Los Angeles, CAS/N 310N6125KBolognese Joseph Jr · Las Vegas, NVBuilt 1947 · S/N 311N6138KBassett Douglas C · Long Lake, NYBuilt 1947 · S/N 324N6175KOptimus Aircraft Service Inc · Middletown, DEBuilt 1947 · S/N 363N6190KMampel Gregory John · New Port Richey, FLBuilt 1947 · S/N 381N6201KLawson William E · Somerset, WIBuilt 1947 · S/N 397N6202KMid Atlantic Air Museum · Reading, PABuilt 1947 · S/N 398N6204KPvb36 Leasing LLC · Denton, TXBuilt 1947 · S/N 404N6208KBishop Bruce L · Durango, COBuilt 1947 · S/N 408N6209KNobleartaviation Inc Trustee · Wilmington, DEBuilt 1947 · S/N 409N6210KPorter Gary O · Oregonia, OHS/N 413N6222KBromschwig Kurt F Trustee · Montgomery, TXBuilt 1947 · S/N 425N6224KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 430N6230KCuny John B · Carlsborg, WABuilt 1947 · S/N 433N6232KCoutches Robert H · Livermore, CABuilt 1947 · S/N 435N6234KNab Air LLC · Idaho Springs, COBuilt 1947 · S/N 437N6239KVrechek Joseph D · Fort Lauderdale, FLS/N 442N6240KJanus William Walter · Belchertown, MABuilt 1947 · S/N 443N62544Brown George H · Youngstown, NYBuilt 1947 · S/N 464N6267KMill Boys Flying LLC · Wilmington, DES/N 477N6272KWoodberry Robert · Mineral, VABuilt 1946 · S/N 482
Back to AD 47-21-13