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.

N2434HBigham Dylan · Windsor, CABuilt 1946 · S/N 3059N2446HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3071N2449HTracy Kevin A · Sequim, WABuilt 1947 · S/N 3074N2467HOmlid Robert L · Watford City, NDBuilt 1946 · S/N 3092N2472HDunlap Lloyd A · Brighton, MIBuilt 1946 · S/N 3097N2475HSchroer Jeffery B · Warrenton, MOBuilt 1946 · S/N 3100N2485HMcnutt Richard K · De Pere, WIBuilt 1946 · S/N 3110N2500HNabb Andrew W · Mooresville, NCBuilt 1946 · S/N 3125N2503HCarlson Lyle V · Allen, NEBuilt 1946 · S/N 3128N2511HGalassi Thomas D · Petersburg, ILBuilt 1946 · S/N 3136N2516HFolk George W · Martinsburg, WVBuilt 1946 · S/N 3141N2523HShadd James A · Lancaster, OHBuilt 1946 · S/N 3148N2525HWilliams Randy Hillman · Blue Ridge, GAS/N 3150N2536HGregory Vernon L · Swansea, SCS/N 3161N2537HMaddock Jay B · Sugar Grove, ILS/N 3162N2539HFortune Conversions Corp · Cave Creek, AZBuilt 1946 · S/N 3164N2546HWing Wendall E · Marion, MIBuilt 1946 · S/N 3171N2551HCoupe Groupe Inc · Bayport, NYBuilt 1946 · S/N 3176N2555HJohns Leroy E · Keenesburg, COBuilt 1946 · S/N 3180N2569HFolk George W · Martinsburg, WVBuilt 1946 · S/N 3194N2576HMartin Aaron M · Penn Yan, NYBuilt 1948 · S/N 3201N2586HDix Walter R Jr · Winter Haven, FLBuilt 1946 · S/N 3211N2593HUpham Chester R III · Mineral Wells, TXBuilt 1946 · S/N 3218N2596HLayne Keith R · Oklahoma City, OKBuilt 1946 · S/N 3221N2597HQuantie Harold · Locust Grove, OKBuilt 1946 · S/N 3222N2602HWilson Rutledge P III · Marietta, GABuilt 1946 · S/N 3227N2606HOlberding Timothy · Bolingbrook, ILS/N 3231N2608HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3233N2627HGarman Karl E · Crystal Lake, ILBuilt 1946 · S/N 3252N2633HGlenn Michael J · Payson, AZBuilt 1946 · S/N 3258N2634HReaser Jordan Scott · Pacific Palisades, CABuilt 1946 · S/N 3259N2642HBennett Steven A · Boylston, MABuilt 1946 · S/N 3267N2650HBreza Thomas S · Laud By Sea, FLS/N 3275N2663HGregory Vernon L · Swansea, SCS/N 3288N2678HGlasser Gene P · Glen Ullin, NDBuilt 1946 · S/N 3303N2679HAbrams David E · Boston, MABuilt 1946 · S/N 3304N2681HFrazier Jesse O · Barnwell, SCBuilt 1946 · S/N 3306N2698HGoodrich James A · Jacksonville, MOBuilt 1946 · S/N 3323N26RRightfooted Foundation International · Tucson, AZBuilt 1946 · S/N 3153N2700HBousquet Arthur David · Highgate Center, VTBuilt 1946 · S/N 3325N2701HRegistration Pending · San Antonio, TXRegistration pendingBuilt 1946 · S/N 3326N2702HHessling Gary G · Trinidad, COBuilt 1946 · S/N 3327N2704HBoelke Ross D · Armada, MIS/N 3329N2714HRey Thomas A · Fort Worth, TXS/N 3339N2715HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3340N271HRegistered aircraftBuilt 1946 · S/N 2306N2727HQuada Andrew W · Lowell, MIBuilt 1946 · S/N 3352N2730HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3355N2735HMorris Robert L · Ulm, MTBuilt 1946 · S/N 3360N2738HDieter Walter T · Salome, AZBuilt 1946 · S/N 3363
Back to AD 46-49-01