AD 46-49-01

Registered aircraft · 1,006

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-49-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-49-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.

N2747HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3372N2749HEngle Elvin Michael · Houston, TXBuilt 1946 · S/N 3374N2756HSoper Steven E · Rathdrum, IDS/N 3381N2757HEtchison Don L · Spring Hill, FLBuilt 1946 · S/N 3382N2758HFitchpatrick Markel C · Blodgett, MOBuilt 1946 · S/N 3383N2766HBennett Bruce M · Louisburg, KSBuilt 1946 · S/N 3391N2771HLambertson Paul C · Surprise, AZBuilt 1946 · S/N 3396N2779JGregory Vernon L · Swansea, SCS/N 976N2784HHudson Jason M · Toccoa, GABuilt 1946 · S/N 3409N2785HBal-Air LLC · Boca Raton, FLBuilt 1946 · S/N 3410N2791HMoore James L · Humboldt, TNBuilt 1946 · S/N 3416N2795HScholten Dirk J · Ames, IABuilt 1946 · S/N 3420N2797HWinters David D · Clarksville, TNBuilt 1946 · S/N 3422N2800HGriggs Geri L · Kingsville, OHFirst renewal noticeBuilt 1946 · S/N 3425N2806HKass John P · Apple Valley, MNBuilt 1946 · S/N 3431N2808HBellomy Andrew · Hasty, COS/N 3433N2816HR & R Outfitters LLC · Kalispell, MTS/N 3441N2820HWelkner Brent G · Guyton, GABuilt 1946 · S/N 3445N2825HMayo Charles S · Woodlawn, TXBuilt 1946 · S/N 3450N2829HMartin D East · Nicholasville, KYBuilt 1946 · S/N 3454N2830HPowell Sherman B III · Pulaski, TNBuilt 1946 · S/N 3455N2831HDon Jones Inc · Orange Beach, ALBuilt 1946 · S/N 3456N2834HClausing Howard F · Menomonie, WIFirst renewal noticeBuilt 1946 · S/N 3459N2837HNorberg John E · Eureka, CABuilt 1946 · S/N 3462N2844HSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3469N2845HGoff Frederick Myron · Vernon, CTBuilt 1946 · S/N 3470N2849HCoupe Brothers LLC · Lopez Island, WABuilt 1946 · S/N 3474N2860HKerr Phillip D · Beebe, ARBuilt 1946 · S/N 3485N2864HKarafit James T · Celina, OHBuilt 1946 · S/N 3489N2865HBayne William R · Kaufman, TXFirst renewal noticeBuilt 1946 · S/N 3490N2869HBeeman Robert P · Central City, PABuilt 1946 · S/N 3494N2872HBevelhymer Paul A · Grass Valley, CABuilt 1946 · S/N 3497N2875HBoley Richard J · Hayward, WIBuilt 1946 · S/N 3500N2876HBurr Walter E II · Tecumseh, MIBuilt 1946 · S/N 3501N2877HHeusdens Mark A · Kansasville, WIBuilt 1946 · S/N 3502N2879HSmith Harry L · Leesburg, FLBuilt 1946 · S/N 3504N2881HMickevicius Theodore A · Gregory, MIBuilt 1946 · S/N 3506N2884HRogers Samuel I · Le Roy, KSBuilt 1946 · S/N 3509N28921Newbury II Dennis M · Brea, CABuilt 1940 · S/N 16N28928Tate Isaac · Yucaipa, CABuilt 1940 · S/N 23N28932Williams Elden G · Redding, CAS/N 27N28939Gregory Vernon L · Swansea, SCBuilt 1941 · S/N 34N28944Knox Raymond F · Clarksville, TNS/N 3394N28960Gregory Vernon L · Swansea, SCS/N 56N28962Summit Aviation Holdings Of Nwa Inc · Rogers, ARBuilt 1941 · S/N 58N2902HFerguson Donald · Creston, OHBuilt 1946 · S/N 3527N2904HBrecke Joshua Carl · Blossvale, NYS/N 3529N2906HZysko Jan A · Ocala, FLBuilt 1946 · S/N 3531N2912HAnderas Per R · Green Bay, WIBuilt 1946 · S/N 3537N2914HChipcraft LLC · Orlando, FLBuilt 1946 · S/N 3539
Back to AD 46-49-01