OpenAirDocs.org
AD 48-50-01

Registered aircraft · 623

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:48-50-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:48-50-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.

N108DFMurtagh Johnny T · Lexington, MSBuilt 1946 · S/N 10860N108WWBingham 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-645N1413AKing John D · Midland, VABuilt 1947 · S/N 1532N1413BSimpson Bradley C · Grandview, TXBuilt 1949 · S/N 1640N14396Tobias Eric · Milwaukee, WIBuilt 1947 · S/N 1509N151CMiller Robert P · Cedar, MIS/N 108-250N1947SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 108-1719N200LGCarty Stephen · Inman, KSBuilt 1946 · S/N 108-108N2101QAtkinson Justin S · Fairbanks, AKBuilt 1946 · S/N 108-1182N211CWells Sherry A Trustee · Ferndale, MIS/N 108-1965N242Ohlmer Ted J · Monterey, CAS/N 1425N25192Cullman Daniel H · Kent, WABuilt 1939 · S/N 1013N25195Andraka Andrew · Newport News, VABuilt 1940 · S/N 1016N2642Edwards Whit · Brookland, ARBuilt 1947 · S/N 108-1515N2643Norman Robert A · Zanesville, OHS/N 108-1516N2649VStedingh Donald M · Anchorage, AKBuilt 1948 · S/N 18159N28972Wahrer Terry J · Cripple Creek, COBuilt 1941 · S/N 1042N28974Friends Of Bellanca Airfield Inc · New Castle, DEBuilt 1941 · S/N 1044N28984Cullman Daniel H · Kent, WABuilt 1941 · S/N 1054N303Behlings Jennifer E · Custer, SDBuilt 1946 · S/N 108-536N33GMMeulenberg Jacobus Mj · Schenevus, NYBuilt 1947 · S/N 1542N340CLindvig Rachel R · Canton, MIBuilt 1947 · S/N 108-3340N358CNicola John T · Coffee Springs, ALBuilt 1947 · S/N 108-3358N35VMGatward Alan J · Fox Island, WABuilt 1947 · S/N 108-2138N3609Macdonald Randall N · Weidman, MIBuilt 1970 · S/N 1-FN386CFlying M Services Inc · Germansville, PAS/N 108-3386N39462Hunton 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-98
Back to AD 48-50-01