OpenAirDocs.org
AD 47-50-06

Registered aircraft · 469

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-06')
    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-06')
  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.

N1049CGerbi Charles R Trustee · Auke Bay, AKS/N 11-1027N1106TPierce John R · Hulett, WYBuilt 1949 · S/N 11-996N113CWDawson John W · Milton Freewater, ORBuilt 1946 · S/N 11-3N11SDavis Susan J · Castroville, CABuilt 1947 · S/N 11-273N1429VTeed Brad S · Vancouver, WAS/N 11-339N143RUpson Theodore C · Newport, NYBuilt 1947 · S/N 11-1520N147PZZattoni Peter D · Mountain Iron, MNBuilt 1947 · S/N 11-1084N149NGerner Carl T · Cadyville, NYBuilt 1947 · S/N 11-1421N162LFFeick Larry E · Crestline, OHBuilt 1947 · S/N 11-162N16686Smith A J · Oneill, NES/N 11-JRS-3N1953NKnutson Wayne R · Thompson, NDS/N 11-820N1967KAir-Ag Inc · Tarboro, NCBuilt 1947 · S/N 11-1523-201N211FHHelm Flying Service Inc · Casselton, NDBuilt 1946 · S/N 19044N2225MBerry Darrel · Camden, TNBuilt 1946 · S/N 21017N23409Miller Harrison · Hallsville, MOS/N 3144N2486AHoudek Dennis E · Roseburg, ORS/N 11-880N2522ERankin Kevin · Maryville, MOS/N 11-843N25730Orton Aviation LLC · Walker, MNBuilt 1940 · S/N 3690N3053PKnutson Wayne R · Thompson, NDS/N 11-895N30766Scotton Bradley D · Galena, AKBuilt 1940 · S/N 5098N3211FJohnson Kenneth E · Sterling, AKBuilt 1974 · S/N 11-238N32673Autry Lonnie E · San Jose, CABuilt 1940 · S/N 5532N32955Finn Kathryn L K · Grand Marais, MNS/N 5739N3316NBender Dennis R · Johnson, VTBuilt 1946 · S/N 22515N333GPBarnes Thomas J · Anchorage, AKBuilt 1948 · S/N 11-446N338PPeters Duane A · Anchorage, AKS/N 11837N3392NStraight Gary D · Wasilla, AKBuilt 1946 · S/N 22594N35499Turner David · Frenchtown, NJBuilt 1941 · S/N 6404N3574WOrton Aviation LLC · Walker, MNBuilt 1946 · S/N 18159N3613KSorenson Kenneth G · Waller, TXBuilt 1946 · S/N 22301N380KPPeterson Timothy J · Watertown, SDBuilt 1947 · S/N 11-1586N38687Geiger William G · Park City, UTBuilt 1948 · S/N 7195N4116DLofstrom Caleb J · Wasilla, AKS/N 11-1580N42239Adkins Clint R · Corvallis, MTBuilt 1945 · S/N 14489N42318Turner Sarah Payson · Hickory Corners, MIBuilt 1945 · S/N 14568N42644Wingnut Inc · Wilmington, DEBuilt 1945 · S/N 14935N4495DHaszard John R · Ophelia, VAS/N 11-506N4502MPletcher Marvin D · Yuma, COBuilt 1947 · S/N 11-6N4505MHayden Joseph C · New York Mills, MNBuilt 1947 · S/N 11-19N4507MToft Patricia A Personal Representative · Myakka City, FLBuilt 1947 · S/N 11-11N4508MJanis Paul H · Anchorage, AKS/N 11-12N4509MNewburg Dale E · Rhome, TXS/N 11-13N4511MSleeper Ken L · Anchorage, AKBuilt 1947 · S/N 11-14N4516MSatran Laurel L · Detroit Lakes, MNBuilt 1947 · S/N 11-20N4525MVeal Tim A · Kenai, AKBuilt 1947 · S/N 11-28N4526MGlasheen Sean T · Bethel, AKBuilt 1947 · S/N 11-31N4528MBatie Russell J · Colstrip, MTBuilt 1947 · S/N 11-32N4532MObrien James P · Mullen, NEBuilt 1947 · S/N 11-36N4533MGaskill Douglas D · Miles City, MTS/N 1138N4535MGold James M · Kerrville, TXBuilt 1947 · S/N 11-39
Back to AD 47-50-06