OpenAirDocs.org
AD 98-17-02

Registered aircraft · 43

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:98-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:98-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.

N106TCollins Michael R · Parker, AZBuilt 1979 · S/N 19288N10GKLong Taylor · Hamilton, TXBuilt 1976 · S/N 19021N10WHOdonnell Michael F · Newtown, PABuilt 1980 · S/N 19322N119JGGrecco Joseph J · Saddle Brook, NJBuilt 1977 · S/N 19137N119LTCilley Sherburn C · South Royalton, VTBuilt 1980 · S/N 19312N11QSNevada Soaring Association Inc · Reno, NVBuilt 1978 · S/N 19210N127JCEllertson Don R · Torrance, CABuilt 1976 · S/N 19031N196HSale Reported · AlbertaSale reportedBuilt 1977 · S/N 19139N19DTAgnew Alfred P · West Palm Beach, FLBuilt 1978 · S/N 19193N19FZTagliani James M · Dewey, AZBuilt 1976 · S/N 19020N19HGSoaring Science Inc · Wilmington, DES/N 19255N19JEKozlik Wiktor · Ramsey, NJBuilt 1978 · S/N 19214N19JNBrannan Patrick S · Saint Louis, MOBuilt 1979 · S/N 19294N19KLRuskauff David J · Geneseo, NYS/N 19058N19LKCanty Jeremiah D · Burke, VABuilt 1981 · S/N 19353N19MLEyler Stuart L · Oceanside, CABuilt 1982 · S/N 19373N19MROpitz Martin H · Seymour, CTBuilt 1978 · S/N 19191N19PLGarbacz Christina B · Chicago, ILBuilt 1977 · S/N 19138N21TWOuroboros Soaring LLC · Salt Lake City, UTS/N 19158N237JFTzerefos Lambros P · Mathews, VAS/N 19156N28TRHouseknecht Thomas J · State College, PAS/N 19419N319HHCampbell Gary A · Boulder, COS/N 19408N31GFTarnoczy Robert I · Corning, NYBuilt 1983 · S/N 19386N333USHutnick Michael C Jr · Bloomsburg, PABuilt 1977 · S/N 19160N34HRRossi Michael A · Pittsboro, NCBuilt 1981 · S/N 19349N37PLTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1978 · S/N 19190N37RBBransford Edward J · Smithfield, VABuilt 1979 · S/N 19295N439ASDezzutti John P · Lakeside, CTS/N 19231N44AULong Nicholas R · Woodinville, WABuilt 1976 · S/N 19061N451ASReynolds John C · Warren, PAS/N 19252N53JCBlack Forest Soaring Association · Monument, COBuilt 1985 · S/N 19415N54619Butler Kenneth L · Mc Leansville, NCBuilt 1977 · S/N 19159N64HRChew Lindsey J · Lafayette, NJBuilt 1978 · S/N 19189N651ASStyker Andrew J · Xenia, OHBuilt 1979 · S/N 19289N78CMKilo 7 LLC · Colorado Springs, COBuilt 1976 · S/N 19070N80SFDi Stefano Fabrizio D · Goose Creek, SCBuilt 1978 · S/N 19194N842CCHolmberg William · Dallas, TXBuilt 1976 · S/N 19069N876FTucson Soaring Club Inc · Sahuarita, AZBuilt 1976 · S/N 19068N888MKLynch William Reymond · Dearborn, MIBuilt 1983 · S/N 19397N97GSWillamette Valley Soaring Club · Cornelius, ORBuilt 1977 · S/N 19140N9814AGreaterboston Soaring Club Inc · Sterling, MABuilt 1978 · S/N 19199N982WTMorse Kathleen A · Groveland, CABuilt 1982 · S/N 19363N99NDHermann Mark A · Glastonbury, CTS/N 19357
Back to AD 98-17-02