AD 68-07-08

Registered aircraft · 196

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:68-07-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:68-07-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.

N51456Saunders David E · Monticello, FLBuilt 1973 · S/N 1107CN51458North Idaho Crushing Inc · Moscow, IDBuilt 1973 · S/N 1114CN51460Sale Reported · Carriere, MSSale reported, pending cancellationS/N 1115CN51463Kelly John Thomas III · Bells, TXS/N 1117CN52TGBarbosa David J · Caribou, MES/N 2126CN540JCFedorko Daniel J · Saylorsburg, PABuilt 1963 · S/N 33N56HBLopez Michael · North Pole, AKBuilt 1972 · S/N 2143CN615SDHolland Andrew K · Sterling, AKS/N 2083CN6JNRinaldi Stephen J · Plymouth, CTBuilt 1970 · S/N 2043CN7602AAlbers Julie H · Burlington Flats, NYS/N 1023N86988Triple W Metal Building Construction LLC · Weatherford, TXBuilt 1973 · S/N 2137CN8880ABroadwell Eric · Woodstock, GAS/N 1108CN8YPClear Blue Marketing Inc · Reno, NVBuilt 1973 · S/N 2187CN9237ZBugden Michael S · Newnan, GABuilt 1969 · S/N 2028CN9243ACollins Carvel Key · Uvalde, TXFirst renewal noticeBuilt 1964 · S/N 71N92WVSilvey Lloyd R · Hale, MOBuilt 1970 · S/N 2040CN9801MUnderwood Mack C · Aiken, SCBuilt 1966 · S/N 2TN9802MBell Andrew J · Moultrie, GABuilt 1965 · S/N 89N9803MJohnson Craig A · Moreland, GAS/N 88N9804MHastie John L III · Bethel, AKBuilt 1965 · S/N 1037N9808MGerling Matthew Karl · Eagle River, AKS/N 1041N9810MPakuer Levi R · Salmon, IDBuilt 1966 · S/N 1020CN9813MGagnebin Michael · Steamboat Springs, COBuilt 1965 · S/N 1036N9816MShaw David H · Nenana, AKBuilt 1966 · S/N 93N9819MBurnett Scott L · Roswell, NMBuilt 1966 · S/N 1005CN9823MKoelsch Benjamin · Nome, AKBuilt 1965 · S/N 1007CN9826MBreitbach Perry J · Circle, MTBuilt 1966 · S/N 1010CN9830MChaney George M · Tellico Plains, TNBuilt 1966 · S/N 1015CN9831MPham Hieu T · Steilacoom, WABuilt 1966 · S/N 92N9838MWaldor Asherjohn · Ford City, PAS/N 2CN9839MRegistered aircraftS/N 1027CN9840MBlackstone Christopher M · Oregon City, ORBuilt 1966 · S/N 1022CN9841MMusser Alvin M Jr · Memphis, MOBuilt 1966 · S/N 3CN9845MRichardson Ronald W Trustee · Stewartville, MNBuilt 1966 · S/N 4CN9846MSchrull Robert E · Brattleboro, VTBuilt 1966 · S/N 3SN9849MAndersen Chris · Forest Grove, ORBuilt 1966 · S/N 1032CN9850MCopeland Tyler G · Prineville, ORS/N 5CN9855MNylund Michael K · Wasilla, AKBuilt 1967 · S/N 1034CN9858MUpton James · Guthrie, OKBuilt 1967 · S/N 9CN9861MSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 1058CN9864MCizek Joseph E · Wasilla, AKS/N 1043CN9865MLaing Thomas L · Aurora, COS/N 2003CN9868MBeckwith Michael E · Kenai, AKS/N 1048CN986RHebblewhite Arthur E · Waunakee, WIBuilt 1971 · S/N 2081CN9872MBatchelder James · Kenai, AKBuilt 1967 · S/N 1054CN9GMColman Scott Preston · Tampa, FLBuilt 1972 · S/N 2131C
Back to AD 68-07-08