OpenAirDocs.org
AD 47-50-12

Registered aircraft · 600

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

N1038BCooper Gerald W · Kennewick, WABuilt 1946 · S/N 108-1020N108DFMurtagh Johnny T · Lexington, MSBuilt 1946 · S/N 10860N108GBusk Richard L · Anchorage, AKS/N 108-1751N108TTTurnbull Archie · Ypsilanti, MIBuilt 1946 · S/N 108-534N108WWBingham Merle G · Hickson, NDBuilt 1946 · S/N 108-384N125HKCarter Steven R · Bend, ORBuilt 1947 · S/N 108-2056N133JMMaggie L Air Service LLC · Kalispell, MTS/N 108-55N136SPSivils Richard Christopher · Healy, AKBuilt 1946 · S/N 108-931N1380CBeltz Ronald K · Delta, OHBuilt 1946 · S/N 108-645N151CMiller Robert P · Cedar, MIS/N 108-250N1947JBendure Mark W · Overland Park, KSBuilt 1947 · S/N 108-2291N1947SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 108-1719N200LGCarty Stephen · Inman, KSBuilt 1946 · S/N 108-108N2070CKnutson Wayne R · Thompson, NDS/N 108-1004N2101QAtkinson Justin S · Fairbanks, AKBuilt 1946 · S/N 108-1182N211CWells Sherry A Trustee · Ferndale, MIS/N 108-1965N222TRHarper David E · Stillwater, MNBuilt 1946 · S/N 108-322N2642Edwards Whit · Brookland, ARBuilt 1947 · S/N 108-1515N2643Norman Robert A · Zanesville, OHS/N 108-1516N269XEliason Alan J · Butte, MTBuilt 1956 · S/N 108-269N303Behlings Jennifer E · Custer, SDBuilt 1946 · S/N 108-536N35VMGatward Alan J · Fox Island, WABuilt 1947 · S/N 108-2138N39462Hunton John C K · Bowdoinham, MES/N 108-18N39470Pike John S · Richmond, INBuilt 1946 · S/N 108-39N39498Finnegan James M · West Valley City, UTBuilt 1946 · S/N 108-29N39CHTennair LLC · Clarksville, TNBuilt 1946 · S/N 108-127N40106Weatherford Verdia G · White Hall, ARBuilt 1946 · S/N 108-36N40107Knutson Wayne R · Thompson, NDBuilt 1946 · S/N 108-37N40114Reves Samuel S · Holly Springs, MSS/N 108-44N40123Gerardi Joseph A · Savannah, GABuilt 1946 · S/N 108-53N40128Weigel Samuel D · Bremerton, WABuilt 1946 · S/N 108-58N40131Browne Travis · Midland, TXS/N 108-61N40140Farwell Jesse R · Albion, NYS/N 108-70N40143Smith David R · Tracy, MNS/N 108-73N40147Padin Leonard · Las Vegas, NVS/N 108-77N40148Evenson Kyle D · Bothell, WABuilt 1946 · S/N 108-78N40152Fagnano Raymond · Columbia, NJBuilt 1946 · S/N 108-82N40153Hudson Kevin D · Half Moon Bay, CABuilt 1946 · S/N 108-83N40157Jones Daniel S · Panama City Beach, FLBuilt 1946 · S/N 108-87N40159Leyner Robert E · Berthoud, COBuilt 1946 · S/N 108-89N40164Morrow Mitchell D · Lexington, GABuilt 1946 · S/N 108-94N40168Roy Aero Service · Grand Marais, MNS/N 108-98N40177Dyrstad William M · Hampshire, ILBuilt 1946 · S/N 108-107N40179Gonzalez Alexander D · Miami, FLS/N 108-109N40181Bear Thomas A · North Hampton, NHBuilt 1946 · S/N 108111N40182Trudnak Michael W · Mansfield Center, CTBuilt 1946 · S/N 108-112N40185Bosko Steven J · San Ramon, CABuilt 1946 · S/N 108-115N401CVan Heel Tyler · Newberg, ORBuilt 1947 · S/N 108-3401N401WRRiddell Warren L · Westbrook, MNBuilt 1946 · S/N 108-401N408Jasinski Jack J · Necedah, WIBuilt 1946 · S/N 108-156
Back to AD 47-50-12