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.

N40177Dyrstad 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-115N401WRRiddell Warren L · Westbrook, MNBuilt 1946 · S/N 108-401N408Jasinski Jack J · Necedah, WIBuilt 1946 · S/N 108-156N411Kepler Justin W · Nikolaevsk, AKFirst renewal noticeBuilt 1946 · S/N 108-159N412First State Ag Air Inc · Viola, DEBuilt 1946 · S/N 108-160N413CWalters Thomas D · Winnsboro, TXBuilt 1947 · S/N 108-3413N427Olson Wesley M · Clovis, NMS/N 1364N43XMajor Ken'S Flying Service LLC · Colfax, NDBuilt 1946 · S/N 108-302N44BSSorensen Raymond D · Anchorage, AKBuilt 1946 · S/N 108-425N47614Trombley Steve DBA · Worland, WYBuilt 1943 · S/N 44N584LWWheelock Larry A · Raymondville, TXBuilt 1946 · S/N 108-584N5GTMeyers Mark R · Ocean Shores, WABuilt 1997 · S/N 195N63XPutney Bruce N · Midlothian, TXBuilt 1958 · S/N E13N6504NBrown Justin G · Folsom, CAS/N 1621N6506NThoms Robert D · Clyde, MIBuilt 1949 · S/N 1624N6507NEack Kenneth B · White Rock, NMBuilt 1949 · S/N 1625N6508NRegistration Pending · Independence, ORRegistration pendingS/N 1627N6668ELeclere Doug D · Coggon, IABuilt 1947 · S/N 108-1-1063N6751MEisenbrey Glen T · Greenbank, WABuilt 1950 · S/N 108-4751N71XPetram William A Trustee · Willow, AKBuilt 1946 · S/N 108-1285N734SCCarden Keith B · Irvington, ALBuilt 1947 · S/N 108-2101N73KVlk Mark J · Moses Lake, WABuilt 1947 · S/N 1154N74213Mullins Mike W · Marshall, TXBuilt 1946 · S/N 1326N74220Grzeskowiak Robert J · Tioga, NDS/N 1333N74221South Carolina Aviation Museum Ltd · Wilmington, DEBuilt 1947 · S/N 1334N74223Mid Atlantic Air Museum · Reading, PABuilt 1946 · S/N 1336N74228King John D · Midland, VABuilt 1946 · S/N 1341N74231Valkyrie Wings LLC · Springville, UTBuilt 1946 · S/N 1344N74235Thorpe Brian J · Saint Augustine, FLBuilt 1946 · S/N 1348N74241Hoover Ronald L · Springfield, MOS/N 1354N74266Stephenson Gary E · Philip, SDBuilt 1946 · S/N 1379N74267Siler Martin R · Macon, GAS/N 1380N74269Tanner Paul Leslie · Savoy, TXBuilt 1947 · S/N 1382N74283Kelly Stephen M · Stonington, CTBuilt 1946 · S/N 1396N74295Snavely William R · Lake Placid, FLBuilt 1946 · S/N 1408N74297Williams David A · Whitewater, WIBuilt 1947 · S/N 1410N74299Doe Gregory P · Smyrna, TNBuilt 1947 · S/N 1412N74314Dale John V · Sahuarita, AZBuilt 1947 · S/N 1427N74337US Flight Academy International Inc DBA · Post, TXBuilt 1947 · S/N 1450N74360Carboneau Luke · Las Cruces, NMS/N 1473N74363Brewington Carl W · Roswell, NMBuilt 1947 · S/N 1476N74364Brannon Lawrence A · Placentia, CABuilt 1947 · S/N 1477N74376Vlk Mark J · Moses Lake, WABuilt 1947 · S/N 1489N74378Goldschmidt Michael · Swanzey, NHBuilt 1947 · S/N 1491N74380Allen Ken · Shelby, NCS/N 1493N74384Record John · Perham, MEBuilt 1947 · S/N 1497
Back to AD 48-50-01