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.

N3143RNelson John J · Salmon, IDBuilt 1967 · S/N 18258543N3143UTimuuu Inc · Alden, NYBuilt 1963 · S/N 18254543N3144QRichmond Brian · Rhome, TXBuilt 1967 · S/N 18258144N3144RGivens Mickey M · Crosbyton, TXBuilt 1967 · S/N 18258544N3144SMyers Dathan Dh · Port Angeles, WABuilt 1964 · S/N 18255644N3145QN3145q LLC · Cave Creek, AZBuilt 1967 · S/N 18258145N3145RSchnell Tyler C · Spearman, TXBuilt 1967 · S/N 18258545N3145SCorriher Ronald R · Mount Ulla, NCBuilt 1964 · S/N 18255645N3145YSiskiyou Aviation LLC · San Jose, CABuilt 1962 · S/N 18254145N3146FMeyer Jackson · Soldotna, AKBuilt 1966 · S/N 18257246N3146QJpw LLC · Red Lodge, MTBuilt 1967 · S/N 18258146N3146RBednarik Edward L · Morgantown, PABuilt 1967 · S/N 18258546N3146UAscend Aviation LLC · Post Falls, IDS/N 18254546N3147CSchlutz Ivan F · Longmont, COBuilt 1954 · S/N 30946N3147QBernbeck Alan R · Benton, KSBuilt 1967 · S/N 18258147N3148CFreund Timothy P · Mesa, AZBuilt 1954 · S/N 30947N3148PSky Hi Aviation LLC · Wilmington, DEBuilt 1977 · S/N 210-61945N3148RMyl High Flying Club LLC · Mccall, IDBuilt 1967 · S/N 18258548N3148SHauser Family Flying LLC · Mount Pleasant, PABuilt 1964 · S/N 18255648N3148YHernandez Alfonso C · Garland, TXBuilt 1962 · S/N 18254148N314BAComer Jacob · Troy, MOBuilt 1962 · S/N 18254547N314FRHawkeye Helicopter LLC · Lyndon, KSBuilt 1998 · S/N 18280260N314MPTeristar LLC · Lewes, DEBuilt 1958 · S/N 51634N314NFWillis Charlotte Y · Belleview, FLBuilt 1960 · S/N 52548N314PYKahn William D · Weddington, NCBuilt 1971 · S/N 18260879N314SOrem John Marshall · Shallowater, TXBuilt 1956 · S/N 33981N314SAAeryn Innovations LLC · Dallas, TXBuilt 2003 · S/N 18281243N314TTSappa Valley Construction LLC · Oberlin, KSBuilt 1961 · S/N 18253457N3150DTransmountain Aviation Inc · Kasilof, AKBuilt 1955 · S/N 31948N3151DVan Aero LLC · Dover, DEBuilt 1955 · S/N 31949N3151FBentley Nicholas Klausing · Reading, PABuilt 1966 · S/N 18257251N3151JStava Robert D · Brainard, NEBuilt 1980 · S/N T18803609TN3151QRairdan Todd G · Vacaville, CABuilt 1967 · S/N 18258151N3151SThomas Darryl · Belfield, NDBuilt 1964 · S/N 18255651N3151YVert James E · Davison, MIBuilt 1962 · S/N 18254151N3152FJk Aviation LLC · Warden, WABuilt 1966 · S/N 18257252N3152QFff Aviation LLC · Land O Lakes, FLS/N 18258152N3152SDavis Lee W · Burns, ORFirst renewal noticeBuilt 1964 · S/N 18255652N3153CCulver Marc D · Anchorage, AKBuilt 1954 · S/N 30952N3153DN3153d LLC · Middletown, DEBuilt 1955 · S/N 31951N3153QMaine Mold & Machine Inc · Hartford, MEBuilt 1967 · S/N 18258153N3154CMitchell Barry C · Sagle, IDBuilt 1954 · S/N 30953N3154DJohnson Daniel P · Pardeeville, WIS/N 31952N3154RKuchera Ray A · Rockdale, TXBuilt 1967 · S/N 18258554N3155CNolan Michael William Jr · Silver Spring, MDBuilt 1954 · S/N 30954N3155DNervino Blake · Turlock, CABuilt 1955 · S/N 31953N3155FHansen Jeremy · Burlington, COBuilt 1966 · S/N 18257255N3155QLandro Rebecca · Puyallup, WAS/N 18258155N3155REnright Matthew R · Skiatook, OKBuilt 1967 · S/N 18258555N3156CMarshall Robert L · Pine River, MNBuilt 1954 · S/N 30955
Back to AD 84-10-01 R1