OpenAirDocs.org
AD 84-10-01 R1

Registered aircraft · 20,483

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

N234MESanfilippo Joseph J · Hollywood, FLBuilt 2000 · S/N 18280751N234PKHintz Courtney N · San Antonio, TXBuilt 1963 · S/N 18254645N234PWRight Rudder LLC · Sapulpa, OKBuilt 1978 · S/N 18266103N234QASteinke Mark · Camas, WABuilt 1959 · S/N 52409N234RCRonnie G Crider Pa · Clearwater, FLBuilt 1985 · S/N R18202012N234THHalbur Lucas R · Omaha, NEBuilt 1978 · S/N 18266386N234TMMisakian David L · Novato, CABuilt 1976 · S/N 18264768N234USouthwest Aviation Enterprises · Haslet, TXBuilt 2005 · S/N 20608230N234WIwaa Inc · Woodstock, GABuilt 1976 · S/N 21061618N2350CKeating John C · Prosper, TXBuilt 1953 · S/N 30650N2350HRieder John · Camarillo, CABuilt 2005 · S/N 18281706N2351CClemens Aviation LLC · Wichita, KSBuilt 1953 · S/N 30651N2351EHog Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 18281707N2351FStewart Anthony D · Blytheville, ARBuilt 1964 · S/N 21058551N2351GBradley John · Edgewood, NMBuilt 1958 · S/N 51651N2351RBrockman Robert L · Christoval, TXBuilt 1964 · S/N 18255451N23521Aircraft Holdings LLC · Missoula, MTBuilt 1998 · S/N 18280418N2352BGwyn Farms Inc · Moses Lake, WABuilt 1998 · S/N 18280416N2352CMcmahan Johana · Gakona, AKBuilt 1953 · S/N 30652N2352MCloud Cap Technology · Hood River, ORBuilt 1999 · S/N 18280417N2352RElkhorn Aviation LLC · Mandan, NDBuilt 1964 · S/N 18255452N2353COverly Terrence Lee · Tok, AKBuilt 1953 · S/N 30653N2353GCascade Aero LLC · Scotts Mills, ORS/N 51653N2353KGraff Lars U · Kohler, WIBuilt 1998 · S/N 18280420N2354CMoma Donald R · Wasilla, AKBuilt 1953 · S/N 30654N2354GJbtg LLC · Poplar Bluff, MOBuilt 1958 · S/N 51654N2354RCarter Bradford J · Rockland, MEBuilt 1964 · S/N 18255454N2354XNorth Coast Aeronautical LLC · Cleveland, OHBuilt 1965 · S/N 18256254N2355CFerguson Edward P · Fargo, NDBuilt 1953 · S/N 30655N2355RLima Mike Inc · Ham Lake, MNBuilt 1964 · S/N 18255455N2355XVan Every Jason E · Cleburne, TXBuilt 1965 · S/N 18256255N2356EHock Aviation LLC · Stuart, FLBuilt 1999 · S/N 18280423N2356GKajans Donald F · Reno, NVBuilt 1958 · S/N 51656N2356LCircle B Pipe & Supply LLC · Odessa, TXBuilt 1998 · S/N 18280425N2356RBledsoe Charles J · Jackson, GABuilt 1964 · S/N 18255456N2357FBachand Kevin L · Leesburg, VABuilt 1964 · S/N 21058557N2357XScavera Kevin · Madras, ORBuilt 1965 · S/N 18256257N2358FEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 21058558N2359FSheldon David E Trustee · Idaho Falls, IDBuilt 1964 · S/N 21058559N2359RTide City Air LLC · Germantown, TNBuilt 1964 · S/N 18255459N2359XHarker Charles R · Suwanee, GABuilt 1965 · S/N 18256259N235AZSchlenker David D · Marine St Crx, MNBuilt 1980 · S/N R18201658N235HLBeach Norman G Jr · Newman, CABuilt 1978 · S/N 18266526N235HP235hp LLC · Norwood, NCBuilt 1998 · S/N 18280333N235MERegistered aircraftBuilt 2000 · S/N 18280753N235PXGons Stephen E · Camp Hill, PABuilt 2022 · S/N 18283176N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797N2360ARegistration Pending · Cedar Falls, IARegistration pendingS/N 20608016N2360CCkt Aviation LLC · Anchorage, AKBuilt 1953 · S/N 30660
Back to AD 84-10-01 R1