OpenAirDocs.org
AD 82-17-02

Registered aircraft · 37

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

N1000ALewis Steven G · Salida, COBuilt 1978 · S/N 3255N100XLLaitinen David P · Raleigh, NCBuilt 1979 · S/N 3401N13TBCcsc Ls3 LLC · Oakwood, OHBuilt 1977 · S/N 3292N20GAMitchell Charles L · Tullahoma, TNS/N 486N216TPTalarek Eva · Far Hills, NJBuilt 1977 · S/N 3073N26DMMori Glenn E · West Ossipee, NHBuilt 1975 · S/N 437N26XCangahuala Laureano A · Claremont, CABuilt 1977 · S/N 3002N27DCPautz Martin R · Alpharetta, GABuilt 1978 · S/N 3306N31SKBryan Danny J · Hobbs, NMBuilt 1975 · S/N 275N328JWilkes Brett A · Newnan, GABuilt 1976 · S/N 480N32JKSamson Philip C · Nashville, TNS/N 3102N40HWBurrows Erik · Lake Forest, CABuilt 1978 · S/N 3279N42TCRegistration Pending · Loveland, OHRegistration pendingBuilt 1975 · S/N 447N430CLSaucedo Robert A · Kingwood, TXBuilt 1976 · S/N 476N45EWDoherty Mark R · Pryor, OKBuilt 1978 · S/N 3224N46895Westenfelder Christof · Salt Lake City, UTS/N 3199N48CWHibbard Bruce A · Layton, UTBuilt 1977 · S/N 3196N4EHHealy Richard A · Chatham, NJBuilt 1977 · S/N 3028N511YRoeske Stanley B · Albuquerque, NMBuilt 1978 · S/N 3275N51801Templin Robert S · Stanhope, NJS/N 3197N52BWNeilson William Andrew · Louisa, VABuilt 1977 · S/N 3198N573JLWood Thomas Edwin Jr · Steamboat Springs, COBuilt 1978 · S/N 3313N57TBluestein Ryan · Garland, TXBuilt 1975 · S/N 406N585Gehrlein Jay L · Waterford, PABuilt 1976 · S/N 477N595ERClark Ronald L · Marysville, WABuilt 1977 · S/N 3046N6108JN6108j LLC · Arlington, VAS/N 272N6LPNuss David A · Cortland, OHBuilt 1975 · S/N 436N707JEFrias Roberto J · Steamboat Springs, COBuilt 1978 · S/N 3225N71JFeldvebel Tom P · Albuquerque, NMBuilt 1978 · S/N 3254N77VLGehrlein Products · Waterford, PABuilt 1976 · S/N 449N78FDYorston John · Boonton, NJBuilt 1977 · S/N 3193N85AAFallah Albert M · Spring, TXBuilt 1978 · S/N 3277N88SGVogt Frederic B · Cedar Grove, WIS/N 261N928VJJamison Douglas M · Eighty Four, PABuilt 1975 · S/N 435N96JHAliante LLC · Longmont, COBuilt 1977 · S/N 3050N99NECloudstreet Ventures Inc · Temple Terrace, FLS/N 3103N9JHBauer Keith Frederick · Taneytown, MDBuilt 1975 · S/N 450
Back to AD 82-17-02