OpenAirDocs.org
AD 49-14-01

Registered aircraft · 2,199

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

N101KRVlach Ronald G · Fremont, NEBuilt 1946 · S/N 12-53N101ZYBartel Gordon L · Willow, AKS/N 12 1935N103BSFixed Gear LLC · Sherwood, ARBuilt 1947 · S/N 123988N103WEEngel Douglas A · Plainfield, ILS/N 2537N1049CGerbi Charles R Trustee · Auke Bay, AKS/N 11-1027N105JHBaxter Brandon C · Wasilla, AKBuilt 1947 · S/N 12-3240N108RHBashaw Nathan R · Salem, NYBuilt 1940 · S/N 5958N10UGraber Paul E · Brooksville, MSBuilt 1940 · S/N 4231N1104GBrowett Don A · Independence, MOBuilt 1947 · S/N 3007N1106TPierce John R · Hulett, WYBuilt 1949 · S/N 11-996N1121WDeleon Joseph M · Saint Petersburg, FLBuilt 1947 · S/N 12-2429N112PATaylor Jay S · Anchorage, AKBuilt 1947 · S/N 12-2158N113CWDawson John W · Milton Freewater, ORBuilt 1946 · S/N 11-3N11CJJackson William A Jr · Hillsboro, ORS/N 3322N11SDavis Susan J · Castroville, CABuilt 1947 · S/N 11-273N12190Cirrus Sr22t 9120 Inc Trustee · Wilmington, DEBuilt 1940 · S/N 5805N12464Bell Todd J · Joliet, MTBuilt 1947 · S/N 12464N126GSSanoski Gregory G · Talkeetna, AKS/N 12-1270N127GSSanoski Gregory G · Talkeetna, AKS/N 12-273N12MZRatfield Dwaine C · Onamia, MNS/N 12-2930N13DBBauer Dereck R · Springfield, ORS/N 12-2919N13YFTemple Peter L · Harrisville, NHS/N 12-848N1406NShirley Tyler A · Dalton, GABuilt 1947 · S/N 22929N1429VTeed Brad S · Vancouver, WAS/N 11-339N143JJKinery Clifford J · Kewadin, MIBuilt 1947 · S/N 12-1705N143RUpson Theodore C · Newport, NYBuilt 1947 · S/N 11-1520N1468NDepoy Lowell K · Salem, INBuilt 1947 · S/N 23001N146MRiddles Michael P · Poulsbo, WABuilt 1946 · S/N 12-703N147PZZattoni Peter D · Mountain Iron, MNBuilt 1947 · S/N 11-1084N149AKSmith Megan · Palmer, AKS/N 121338N149NGerner Carl T · Cadyville, NYBuilt 1947 · S/N 11-1421N14HRRegistered aircraftBuilt 1947 · S/N 12-2853N14LGRichards William · Gardiner, NYBuilt 1981 · S/N 401N1553MRubbert Jan D · Upham, NDBuilt 1947 · S/N 12-3125N157PJCarnighan Kelly · New Albany, INBuilt 1946 · S/N 12-1152N15JKCaskey Martin K · Paso Robles, CABuilt 1946 · S/N 12-265N160HLProbasco Mitchell L · Floydada, TXBuilt 1946 · S/N 12-1636N162LFFeick Larry E · Crestline, OHBuilt 1947 · S/N 11-162N16686Smith A J · Oneill, NES/N 11-JRS-3N16PDMurphy Frank · Quitman, GABuilt 1945 · S/N 14699N1706BWagstrom Wayne A · Aurora, UTS/N 12-1562N170WTBarber Shane C · Willow, AKS/N 12-753N17NVLeseberg Mark E · Boulder City, NVBuilt 1946 · S/N 12-863N17RBN17rb LLC · Fredericksburg, PABuilt 1946 · S/N 16314N1947YBitterroot Ventures LLC · Show Low, AZBuilt 1947 · S/N 12-3253N1953NKnutson Wayne R · Thompson, NDS/N 11-820N1967KAir-Ag Inc · Tarboro, NCBuilt 1947 · S/N 11-1523-201N19MYCamino Thomas J · Buffalo, WYBuilt 1946 · S/N 12-2274N1SETin Cup Aviation LLC · Lakeland, FLBuilt 1947 · S/N 12-2036N20156Fazzolare Dennis J · Strabane, PABuilt 1938 · S/N 2233
Back to AD 49-14-01