OpenAirDocs.org
AD 97-08-06 R1

Registered aircraft · 607

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:97-08-06-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:97-08-06-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.

N4246BMahony John · Ballston Spa, NYBuilt 1978 · S/N 117N424BGSt Louis Soaring Association Inc · Saint Louis, MOS/N 5548CBN427BGAlbuquerque Soaring Club Inc · Albuquerque, NMBuilt 1982 · S/N 3739N4281BNagel Wanda · Placerville, CABuilt 1978 · S/N 123N429BGCherryhill Flying Club LLC · Freetown, INBuilt 1982 · S/N 3737N42TCRegistration Pending · Loveland, OHRegistration pendingBuilt 1975 · S/N 447N430CLSaucedo Robert A · Kingwood, TXBuilt 1976 · S/N 476N432MSilberer Gabor Z · Parker, COBuilt 1977 · S/N 20512N43929Henry James R · Lakeville, MNBuilt 1977 · S/N 81N439ASDezzutti John P · Lakeside, CTS/N 19231N43JHHuntsville Soaring Assn · Brownsboro, ALBuilt 1983 · S/N 3806N441UJBruce Robert H · Boerne, TXBuilt 1969 · S/N 55N44259Sandhill Soaring Club Inc · Brighton, MIBuilt 1983 · S/N 3790N4425YRudloff Uwe K · Lake Village, INBuilt 1983 · S/N 3820N4426BN4426b LLC · Hood River, ORBuilt 1983 · S/N 3791N4446TWeller Steven C · Hummelstown, PABuilt 1983 · S/N 3824N4446WKnauff And Grove Inc · Julian, PABuilt 1983 · S/N 3822-K-81N4446YUtah Soaring Association · Mapleton, UTBuilt 1983 · S/N 3825N446EOngstad Clifford C · Surprise, AZBuilt 1973 · S/N 446N44AULong Nicholas R · Woodinville, WABuilt 1976 · S/N 19061N451ASReynolds John C · Warren, PAS/N 19252N45748Central Indiana Soaring Society Inc · Yorktown, INS/N 3828N45DGTrumbly Robert Allen · Gardnerville, NVS/N 4-36N45KAShumaker Timothy R · Brevard, NCBuilt 1977 · S/N 20589N4601MSouthern California Soaring Academy Inc · Valencia, CAS/N 3831N468EMoore Michael D · Durham, MES/N 356GN468SASouthern California Soaring Academy Inc · Valencia, CABuilt 2014 · S/N 21908N46JDKarst Max H · Seattle, WABuilt 1976 · S/N 20145CN474KSValley Soaring Club Inc · Middletown, NYBuilt 1983 · S/N 21197N4793NSb3 Asset Management LLC · Gilbert, AZBuilt 1984 · S/N 3842-K-88N4794EBig Q Aviation · Midlothian, TXBuilt 1984 · S/N 3843-K-89N47ZLovin Mark J · Longmont, COBuilt 1975 · S/N 20098N4805RAgcsc Foundation Inc · Jacumba, CABuilt 1984 · S/N 3854-K-100N480JNatkiel Paul · Hanover, NHBuilt 1977 · S/N 48N484AJSkytow De LLC · Middletown, DEBuilt 2012 · S/N 21898N484SAPrather David W · Cameron Park, CABuilt 1970 · S/N 15063N487GCPhiladelphia Glider Council Inc · Hilltown, PABuilt 1989 · S/N 34123N49765Preston Shane M · Tuttle, OKBuilt 1973 · S/N 353N4990GHigh Alpine Restaurant Ahcs Inc · Snowmass Village, COBuilt 1972 · S/N 267N499EBlaser Terry G DBA · Liberal, KSS/N 4-99N49JJFun Country Soaring · Valley City, OHBuilt 1983 · S/N 5606CBN4CCBrown Leslie Albert · Saint Clair Shores, MIBuilt 1972 · S/N 187N4HTMitchell Lawrence W S · San Antonio, TXBuilt 1978 · S/N 20637N4QDWichita Skylarks Soaring · Wichita, KSBuilt 1981 · S/N 3687-K-38N4RFJurado Alfonso E · Miami, FLS/N 338N4ZDCoussens Thomas · Valencia, CABuilt 1978 · S/N 20620N503VKleinhempel Uwe · Minden, NVBuilt 1990 · S/N 5E24 M12N505GGWxca LLC · Edmonds, WAS/N 5E161M61N505KAFairbairn Jacob Andrew · Fort Worth, TXS/N 50N507AWFreitas Norman Joseph · North Fort Myers, FLS/N 3373
Back to AD 97-08-06 R1