OpenAirDocs.org
AD 59-10-08

Registered aircraft · 1,184

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:59-10-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:59-10-08')
  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-649N101SCAnderson Benjamin T · Havre De Grace, MDBuilt 1964 · S/N 18-6200N1023AWhite 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-606N1041AWinkelman Donald L · Anchorage, AKBuilt 1951 · S/N 18-619N1045ALange Bryan C · Harrison, NEBuilt 1951 · S/N 18-622N104TCarey Daniel F · Rockville Centre, NYS/N 18-2218N1051ARegistered aircraftBuilt 1951 · S/N 18-641N1059AButler Billy D · Hilger, MTBuilt 1951 · S/N 18-630N105JCHeckathorn Chad W Trustee · Elk Point, SDBuilt 1950 · S/N 18-308N1065ANordhaus 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-680N1097ARanch Aero LLC · Sterling City, TXS/N 18-685N1099PHansen K Brent · Captain Cook, HIS/N 20-510N10PSCarson Glen W · Garber, OKBuilt 1955 · S/N 22-2687N1106CRiver Town Aviation LLC · Williamstown, WVS/N 22-948N1109AOrton 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-5946N1123CTuschhoff 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-721N1130ACoxon William O IV · Church Hill, MDBuilt 1951 · S/N 18-723N1131ARizzo Christian · Clover, SCBuilt 1951 · S/N 18-725N1140CAtkins Alvin R · Barnstead, NHBuilt 1953 · S/N 22-973N1144AKramer John Edward · Conroe, TXBuilt 1951 · S/N 18-737N1148ATyrrell Luke L · Fairbanks, AKBuilt 1951 · S/N 18-742N1157CCavill Wayne E · Ryegate, MTBuilt 1953 · S/N 18-2458N1160AAday Bennie J · Las Cruces, NMS/N 18-757N1167CMountain Bluebird Aviation LLC · Kalispell, MTBuilt 1953 · S/N 22-992N1168CPartridge James R · Chino Valley, AZBuilt 1953 · S/N 22-994N1171CUnser Joshua D · Anchorage, AKBuilt 1953 · S/N 20-963N1175ABurmeister Aaron R · Nenana, AKBuilt 1951 · S/N 18-777N117TLOver-Head Productions Inc · Wilmington, DES/N 18-2231N1185ALovgren Dean · Morrowville, KSBuilt 1951 · S/N 18-792N1189CHorton Harold E · Jber, AKS/N 18-2470N118DKReynolds Thomas J · Dillon, MTS/N 18-7540N118EMSharp Robert M Trustee · Jenks, OKS/N 18-1853N118UCypher Tosha · Palmer, AKS/N 22-3988
Back to AD 59-10-08