OpenAirDocs.org
AD 52-17-01

Registered aircraft · 131

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:52-17-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:52-17-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.

N1413AKing John D · Midland, VABuilt 1947 · S/N 1532N1413BSimpson Bradley C · Grandview, TXBuilt 1949 · S/N 1640N14396Tobias Eric · Milwaukee, WIBuilt 1947 · S/N 1509N242Ohlmer Ted J · Monterey, CAS/N 1425N29TJRegistration Pending · Bear Creek, PARegistration pendingBuilt 1946 · S/N 1174N33GMMeulenberg Jacobus Mj · Schenevus, NYBuilt 1947 · S/N 1542N413RPalmer Earl S · Lewiston, IDBuilt 1947 · S/N 1531N427Olson Wesley M · Clovis, NMS/N 1364N44FPShipman William L · Mc Calla, ALBuilt 1946 · S/N 1096N6504NBrown 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 1627N6520NDemeyer Scott M · Olympia, WABuilt 1949 · S/N 1641N6523NJenkins Grant W · Seattle, WAS/N 1644N73KVlk Mark J · Moses Lake, WABuilt 1947 · S/N 1154N74203Gray David M · Albuquerque, NMBuilt 1946 · S/N 1316N74212Hartman Dave · Miles City, MTS/N 1325N74213Mullins 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 1344N74233Hunter James Rogers · Schertz, TXBuilt 1946 · S/N 1346N74235Thorpe Brian J · Saint Augustine, FLBuilt 1946 · S/N 1348N74241Hoover Ronald L · Springfield, MOS/N 1354N74257Norton John B · Colorado Springs, COBuilt 1946 · S/N 1370N74266Stephenson Gary E · Philip, SDBuilt 1946 · S/N 1379N74267Siler Martin R · Macon, GAS/N 1380N74269Tanner Paul Leslie · Savoy, TXBuilt 1947 · S/N 1382N74281Szostak Edward M · San Diego, CABuilt 1946 · S/N 1394N74282Santana Joseph W · Waynesboro, VABuilt 1946 · S/N 1395N74283Kelly 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 1412N74313Kraus Russell E · Albemarle, NCS/N 1426N74314Dale John V · Sahuarita, AZBuilt 1947 · S/N 1427N74337US Flight Academy International Inc DBA · Post, TXBuilt 1947 · S/N 1450N74360Carboneau Luke · Las Cruces, NMS/N 1473N74362Vlk Mark J · Moses Lake, WAS/N 1475N74363Brewington Carl W · Roswell, NMBuilt 1947 · S/N 1476N74364Brannon Lawrence A · Placentia, CABuilt 1947 · S/N 1477N74372Smith Randall P · Ft Worth, TXBuilt 1947 · S/N 1485N74376Vlk 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 1497N74392Goodman William R · Opelika, ALBuilt 1947 · S/N 1505
Back to AD 52-17-01