OpenAirDocs.org
AD 74-20-08

Registered aircraft · 162

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:74-20-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:74-20-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.

N107YYBeezhold Terence J · Lake Stevens, WABuilt 1956 · S/N 35266N1113TWirthlin Donald K · Sierra Vista, AZBuilt 1957 · S/N 35561N11220Southern Arkansas University Tech · Camden, ARBuilt 1957 · S/N 38037N112HRFlexer Howard · Monterey Park, CAS/N 35217N115CKSchmick Kenneth R · Fond Du Lac, WIS/N 35281N116BGGood Bill T · Temecula, CABuilt 1955 · S/N 35116N11DEPeile Kelly · Lakeview, ORS/N 38087N12144Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1958 · S/N 31038118N125ETGrindeland Ethan P · Hatton, NDBuilt 1958 · S/N 35706N129CMWoodhaven Air LLC · Blue Springs, MOBuilt 1958 · S/N 35625N153RJones Jeremy R · Lampasas, TXS/N 35020N16SGWard James · Arroyo Grande, CABuilt 1957 · S/N 35591N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229N1956Sturges George S Jr · Bakersfield, CABuilt 1956 · S/N 35337N196RLunsford Joel T · Jasper, TXBuilt 1955 · S/N 35049N200LEAeromarine Holdings LLC · Waukesha, WIBuilt 1979 · S/N 310R1842N215AMurphy Dan A · Two Harbors, MNBuilt 1954 · S/N 35013N2199CMorris Thomas B · Imlay City, MIBuilt 1958 · S/N 38081AN223HWatson James E Jr · Victor, COBuilt 1956 · S/N 35385N2277FEagle Mission LLC · Keystone Heights, FLBuilt 1956 · S/N 35352N237DWTheis Industrial Leasing Inc · Spivey, KSS/N 35506N255AOld Aircraft Inc · Lake City, FLBuilt 1956 · S/N 35285N2602CRrb Aviation LLC · Jasper, TXBuilt 1954 · S/N 35002N2610CNelson Scott J · Saline, MIBuilt 1954 · S/N 35010N261REPeterson Randy J · Sonoma, CAS/N 35284N2638CPickett Joseph C · El Paso, TXBuilt 1955 · S/N 35038N2642CMuniz Elmer · Port Saint Lucie, FLS/N 35042N2655CSmith Lionel J · Ironton, MOBuilt 1955 · S/N 35055N2671CHouchen Chris F · Palmer, AKBuilt 1955 · S/N 35071N2672CClipper Sky LLC · Las Vegas, NVS/N 35072N2674CTri County Sprayers Inc · Hamlin, TXBuilt 1955 · S/N 35074N2689CColvin Clu DBA · Big Cabin, OKS/N 35089N2695CNovak Peter A · Barrington, ILBuilt 1955 · S/N 35095N2UMHepfer John Edward · Midland, TXBuilt 1958 · S/N 35649N2WTJohnson Michael A · Winter Park, COS/N 38117N3003DRoach James M · West Bountiful, UTBuilt 1955 · S/N 35203N3006DWarmkesserl James R · Felton, CABuilt 1955 · S/N 35206N3020DAllen Gregory L · Lake View, ALBuilt 1955 · S/N 35220N3025DBanducci Debra L Trustee · Bakersfield, CABuilt 1955 · S/N 35225N3061DJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1956 · S/N 35261N3063DCase William M · Klamath Falls, ORBuilt 1956 · S/N 35263N3064DLebron R Luke · Gulfport, MSS/N 35264N3069DSmith Gregory E · White Lake, MIBuilt 1956 · S/N 35269N3091DBella Farms Inc · Hayes Center, NEBuilt 1956 · S/N 35291N3094DAberdeen Pilots LLC · Boerne, TXBuilt 1956 · S/N 35294N3095DIrvine William G · Rosamond, CABuilt 1956 · S/N 35295N310EBWeatherproof Montana LLC · Missoula, MTBuilt 1956 · S/N 35446N310JTCowan David E · Mount Pleasant, SCBuilt 1956 · S/N 35486N310KTSmith Gregory E · White Lake, MIBuilt 1958 · S/N 38122N310LEJones Kent D · St George, UTS/N 35425
Back to AD 74-20-08