AD 46-39-01

Registered aircraft · 62

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

N21164Christenson Dean A · Intl Falls, MNS/N 7049N21165Stewart Donald J · Charlotte, NCBuilt 1939 · S/N 7024N21169Warren John P · White Lake, MIBuilt 1939 · S/N 7028N21186Lea Richard M · Pasadena, MDBuilt 1939 · S/N 7062N21195Williams John David · Omaha, NEBuilt 1939 · S/N 7134N2131CJoyce Edward R · Jefferson, OHBuilt 1940 · S/N 7723N22502Pennell Timothy M · Hickory, NCBuilt 1939 · S/N 7076N22513Sutton Bradley V · Dallas, TXBuilt 1939 · S/N 7083N22517Alseth Elif A · Rockton, ILS/N 7061N22531Coleman Burgess · S Lyon, MIBuilt 1939 · S/N 7099N22543Rawson John · Orange, CAS/N 7106N22546Elliott Brandon J · Senoia, GAS/N 7128N22548V2 Aviation LLC · Mishawaka, INBuilt 1939 · S/N 7131N22579Sutton Bradley V · Dallas, TXS/N 7157N23701Jackson Ramman S · Los Angeles, CABuilt 1939 · S/N 7170N23703Ackerman Jerry L · Spring, TXS/N 7150N23706Petersen Lewis C · Salisbury Center, NYBuilt 1939 · S/N 7189N23710Klein John T · Austin, ARBuilt 1939 · S/N 7173N23741Morris John B Jr · Kenai, AKBuilt 1939 · S/N 7211N23784St Clair Joseph M · Wills Point, TXBuilt 1939 · S/N 7244N23785Ackerman William L · Montgomery, TXBuilt 1940 · S/N 7260N23792Swartz William L · Cumb Foreside, MES/N 7247N26200Ulmer Clarence G · Aladdin, WYBuilt 1940 · S/N 7501N26204Ton David B · Bremen, INS/N 7258N26219Ekin William A · Port Alsworth, AKBuilt 1940 · S/N 7505N26223Park Derek B · Lyons, GABuilt 1940 · S/N 7510N26246Pederson William K · Hillsboro, ORBuilt 1940 · S/N 7533N26249Patrick Ronald A · Louisville, KYBuilt 1955 · S/N 7535N26265Rogers B L · Martinsburg, WVBuilt 1940 · S/N 7552N26275Bresser Jason R R · Soldotna, AKS/N 7559N26279Dorris Terry E · Greenbrier, TNBuilt 1940 · S/N 7560N26281Houghton Andrew P · Cypress, TXBuilt 1940 · S/N 7567N26284Rupke Curtis · Winterville, NCS/N 7570N26285Stinson 10 LLC · Owosso, MIBuilt 1940 · S/N 7576N26290Black Stephen L · Urbandale, IABuilt 1940 · S/N 7575N26295Mott William R · Beach Lake, PABuilt 1940 · S/N 7582N26409Frick Gary A Trustee · Marion, INS/N 7600N26419Blackwater Aviation LLC · Holt, FLBuilt 1940 · S/N 7610N26439Warren John P · White Lake, MIBuilt 1940 · S/N 7617N26441Historical Aircraft Squadron Inc · Carroll, OHS/N 7635N26448Reid David · Houston, TXBuilt 1940 · S/N 7671N26449Ritenour John · Knoxville, TNBuilt 1940 · S/N 7639N27708Wightman Randy A · Owosso, MIBuilt 1940 · S/N 7643N27710Airpower Museum Inc · Ottumwa, IABuilt 1940 · S/N 7655N27732Shadwick Clarence R · Tunnel Hill, GAS/N 7670N27740California Antique Aircraft Museum · San Martin, CABuilt 1940 · S/N 7690N27757Davey Kenneth E · Lake Crystal, MNBuilt 1940 · S/N 7696N27776Bauer Mark A · Palmer, AKS/N 7720N31504Gendron Matthew · Port Orange, FLS/N 7749N31507Hackenburg Jess P II · Montoursville, PABuilt 1940 · S/N 7727
Back to AD 46-39-01