OpenAirDocs.org
AD 47-50-09

Registered aircraft · 174

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

N1010WLawlor Stephen M · Saint Joseph, MOBuilt 1946 · S/N R46-253N1276NGreek Housing Services Corp · Port Matilda, PAS/N W-41A-371N147ABEngel Leland E · Avoca, MIBuilt 1943 · S/N W41A-511N14988Penney John C Trustee · Evergreen, COBuilt 1943 · S/N 952N1595Omeara Jeffrey Ryan · Bainbridge Island, WABuilt 1939 · S/N R9-427N18652Butler County Warbirds Inc · Middletown, OHBuilt 1952 · S/N R9-422N18682Collins John P · El Cajon, CABuilt 1939 · S/N R9-424N18684Walk Michael · Englewood, FLBuilt 1939 · S/N 201N18688Pfou Michael G · Princeton, MNBuilt 1939 · S/N W-101N18695Champaign Aviation Museum · Urbana, OHBuilt 1939 · S/N W213N20619Smith Happy E · Rogersville, TNBuilt 1939 · S/N 300N20628Lipsett Rory · Lancaster, PABuilt 1939 · S/N R9-403N20632Hagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1939 · S/N R9-405N22032Sharpe Rusty C · Murchison, TXS/N 205N22036Miller David J · Fernandina Beach, FLBuilt 1940 · S/N W40-105N22047Harris Jeremy B · Boring, ORS/N W9-119N224DBBongiovanni Joseph T · Ocala, FLBuilt 1946 · S/N R46264N2302Schmidt Aaron B · Auburn, ALBuilt 1939 · S/N 304N232EThomson Scott R · Street SomersetS/N R40-425N23VWomack Jeffrey · Jackson, LABuilt 1946 · S/N W46-134N24FAWullner Leeroy J · Cedar Rapids, IAS/N 921N24FMCoon Robert E · Warrenville, ILBuilt 1970 · S/N HB690N25183Smith Happy E · Rogersville, TNBuilt 1940 · S/N W40-107N25185Bruggeman Steven S · Shoreview, MNBuilt 1940 · S/N 108N25323Zechini Marcus Kenneth · White Post, VAS/N W40-111N25327Neal Sean Edward · Freehold, NYBuilt 1950 · S/N W40-113N25329Hargreaves William A · Lovettsville, VAS/N R40-404N25392Walker Joseph E · Hoodsport, WAS/N R40-409N282FCClassic Toy Barn LLC · Central Islip, NYS/N R46261N28517Port Townsend Aero Museum · Port Townsend, WAS/N W40-129N28521Carey Richard L · Hagerstown, INBuilt 1940 · S/N W40-135N28522Lowe Anthony E · Edina, MNBuilt 1940 · S/N 136N28525Barrett Brian W · Bellevue, WABuilt 1940 · S/N W40-134N28533Shelly Mark P · Buckley, WABuilt 1940 · S/N W40-140N28636Natoli Nathaniel T · Rutland, VTBuilt 1940 · S/N W40-151N28640Bormuth Alan R · Morganton, NCBuilt 1940 · S/N W40-160N28642Van Buren Karen A · Mchenry, ILS/N W40-162N28644Mustang Holdings LLC · Omaha, NEBuilt 1940 · S/N W40-164N28648Lombardi Andrew J · Santa Paula, CAS/N W40-148N28685Dienst Lon C · Poplar Grove, ILS/N W-40-168N28690Fortin Russell J · Linden, MIS/N W41A-111N28691Whelan Thomas M · Bethlehem, CTBuilt 1941 · S/N W41A-201N29009Mclean Diane A · Weirsdale, FLBuilt 1941 · S/N W41110N29010Gonzales Donald M · Columbia Station, OHBuilt 1940 · S/N W40-174N295YWegmueller Daniel E · Monroe, WIBuilt 1940 · S/N W40-102N306WAllen Cheryl L · Hilltop Lakes, TXBuilt 1939 · S/N R9-407N37161Museum Of Flight Foundation · Seattle, WABuilt 1941 · S/N W41A-206N404Bertrand Jeff J · Willow, AKBuilt 1940 · S/N 172N4263SRobbins III James E · Lakeland, TNBuilt 1946 · S/N W46299N46499Flying L Aircraft Inc · Fort Denaud, FLBuilt 1943 · S/N W41A-577
Back to AD 47-50-09