OpenAirDocs.org
AD 93-10-06

Registered aircraft · 4,265

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

N1009AWilliams Wendell · Anchorage, AKBuilt 1950 · S/N 18581N101KCH O Aircraft Inc · Maple Grove, MNS/N 18-649N101KRVlach Ronald G · Fremont, NEBuilt 1946 · S/N 12-53N101SCAnderson Benjamin T · Havre De Grace, MDBuilt 1964 · S/N 18-6200N101ZYBartel Gordon L · Willow, AKS/N 12 1935N1023AWhite Leland T · Deer Park, WABuilt 1951 · S/N 18-595N1023NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 18-1889N102LWWulff Allan · Reston, VABuilt 1955 · S/N 18-4383N1034AHawk Don · Shady Cove, ORS/N 18-606N103BSFixed Gear LLC · Sherwood, ARBuilt 1947 · S/N 123988N1041AWinkelman Donald L · Anchorage, AKBuilt 1951 · S/N 18-619N1044TSnyder Otho J · Underwood, NDS/N 5-628N1045ALange Bryan C · Harrison, NEBuilt 1951 · S/N 18-622N1049CGerbi Charles R Trustee · Auke Bay, AKS/N 11-1027N104TCarey Daniel F · Rockville Centre, NYS/N 18-2218N1051ARegistered aircraftBuilt 1951 · S/N 18-641N1059AButler Billy D · Hilger, MTBuilt 1951 · S/N 18-630N105FVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1940 · S/N 5-477N105JCHeckathorn Chad W Trustee · Elk Point, SDBuilt 1950 · S/N 18-308N105JHBaxter Brandon C · Wasilla, AKBuilt 1947 · S/N 12-3240N1065ANordhaus Robert · Lake Geneva, WIBuilt 1951 · S/N 18-648N1066AYounggren James H · Hallock, MNBuilt 1951 · S/N 18-646N1072AScarboro Thomas E · North Pole, AKBuilt 1951 · S/N 18-655N1073APeters Steven M · Parkersburg, WVBuilt 1951 · S/N 18-657N1076ATri City Airframe LLC · Kalispell, MTS/N 18-659N1081AHoyer Larry B · Fort Peck, MTBuilt 1951 · S/N 18-663N10842Cranor Douglas R · Valdez, AKBuilt 1951 · S/N 18-671N1087AScotton Bradley D · Galena, AKBuilt 1951 · S/N 18-673N1089AReeder Julian S Jr · Nenana, AKS/N 18-680N108PCRegistered aircraftBuilt 1948 · S/N 16-322N1097ARanch Aero LLC · Sterling City, TXS/N 18-685N1099PHansen K Brent · Captain Cook, HIS/N 20-510N109NBiggest Edward J · Cornell, ILBuilt 1939 · S/N 4-716N10PSCarson Glen W · Garber, OKBuilt 1955 · S/N 22-2687N1106CRiver Town Aviation LLC · Williamstown, WVS/N 22-948N1106TPierce John R · Hulett, WYBuilt 1949 · S/N 11-996N1109AOrton Aviation LLC · Walker, MNBuilt 1951 · S/N 18-701N1109JOrton Aviation LLC · Walker, MNBuilt 1950 · S/N 18-392N1109WOrton Aviation LLC · Walker, MNBuilt 1957 · S/N 18-5946N1117HSenf Raymond L · Central Square, NYS/N 15-332N1121WDeleon Joseph M · Saint Petersburg, FLBuilt 1947 · S/N 12-2429N1123CTuschhoff Stetson Rd · Jackson, MOBuilt 1953 · S/N 22-960N1127ASerie Dennis P · Chugiak, AKBuilt 1950 · S/N 18-720N11284Horton Rick S · Plains, MTBuilt 1956 · S/N 18-4737N1128ACarson Dean B · Anchorage, AKBuilt 1951 · S/N 18-721N112PATaylor Jay S · Anchorage, AKBuilt 1947 · S/N 12-2158N1130ACoxon William O IV · Church Hill, MDBuilt 1951 · S/N 18-723N1131ARizzo Christian · Clover, SCBuilt 1951 · S/N 18-725N113CWDawson John W · Milton Freewater, ORBuilt 1946 · S/N 11-3N113PATundra Aviation Inc · Casselton, NDBuilt 1948 · S/N 14-113
Back to AD 93-10-06