OpenAirDocs.org
AD 47-51-13

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:47-51-13')
    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-51-13')
  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.

N74411Schmidt Wilfred L · Elgin, ILS/N 1524N74413Cullman Daniel H · Kent, WABuilt 1947 · S/N 1526N74414Sherard Dale Edward · Marsing, IDBuilt 1947 · S/N 1527N74424Hannagan Michael F · Endicott, NYBuilt 1947 · S/N 1537N74428Tidd Jessica Marie · Reading, MIBuilt 1947 · S/N 1541N74431Parsons John C · Wichita, KSBuilt 1947 · S/N 1544N74445Vlk Mark J · Moses Lake, WAS/N 1558N74450Nutter Michael S · University Place, WABuilt 1947 · S/N 1563N74455Bell Joseph B · Tiffin, OHS/N 1568N74466Weakley Byron D · Chapmansboro, TNBuilt 1948 · S/N 1579N74467Anagnos Nick C · East Moline, ILBuilt 1948 · S/N 1580N74474B & C Specialty Inc · Johnston, IAS/N 1587N74482Fox John E · Boonville, CABuilt 1948 · S/N 1595N74484Kraus Russell E · Albemarle, NCS/N 1597N74487Pierce David J · Alpine, UTS/N 1600N74490Wheeler Joellyn K · Collegedale, TNBuilt 1948 · S/N 1603N74492Thoms Robert D · Clyde, MIBuilt 1948 · S/N 1605N74497Walentoski Gary E · Baytown, TXFirst renewal noticeBuilt 1948 · S/N 1592N75329Prentice Robert D · Ripon, WIBuilt 1947 · S/N 1371N772Greene James H · Hosckton, GABuilt 1946 · S/N 1273N77AYGould Russell Pearce · May, TXS/N 1156N77HLBarton Bruce N · White Hills, AZS/N 1084N86700Wahrer Terry J · Cripple Creek, COBuilt 1946 · S/N 1061N86703Sale Reported · Chickasha, OKSale reportedBuilt 1946 · S/N 1064N86716Marks Ronald F · Moreno Valley, CABuilt 1946 · S/N 1077N86719Holmberg Harold B · Stillwater, MNBuilt 1946 · S/N 1080N86720Carpenter Teri R · Gearhart, ORS/N 1081N86725Thoms Robert D · Clyde, MIS/N 1086N86726Sale Reported · Mesa, AZSale reportedBuilt 1946 · S/N 1087N86728Seymour Keith R · Americus, GABuilt 1946 · S/N 1089N86729Wolcott Jim · Grandview, TXBuilt 1946 · S/N 1090N86737Beasley Glen R · Brandon, MSBuilt 1946 · S/N 1098N86739Woodbridge Arlen M · Rupert, IDBuilt 1946 · S/N 1100N86744Mcdonald Michael · Littlerock, CABuilt 1946 · S/N 1105N86745Baltzley Doug · Santa Fe, NMBuilt 1946 · S/N 1106N86746Price Norman P · Live Oak, FLBuilt 1946 · S/N 1107N86757Cooper Craig A · Owasso, OKBuilt 1946 · S/N 1118N86759Vlk Mark J · Moses Lake, WABuilt 1946 · S/N 1120N86761William Hamilton Arthur Architect Inc · Coral Gables, FLBuilt 1946 · S/N 1122N86763Bagley Corydon R · South Jordan, UTBuilt 1946 · S/N 1124N86766Best Charles K · Lumberton, NCBuilt 1946 · S/N 1127N86768Tarver Dalton K · Fallon, NVBuilt 1946 · S/N 1129N86771Seratt Timothy G · Harviell, MOBuilt 1946 · S/N 1132N86772Sills Joseph G · Bastrop, TXS/N 1133N86786Goldschmidt Michael · Swanzey, NHBuilt 1946 · S/N 1147N86787Olson Wesley M · Clovis, NMBuilt 1946 · S/N 1148N86794Diamond Dale A · Tinton Falls, NJBuilt 1946 · S/N 1155N86800Petik Neil L · Barney, NDBuilt 1946 · S/N 1161N86802Bell Joseph B · Tiffin, OHBuilt 1946 · S/N 1163N86806Officer Jarod P · Petaluma, CABuilt 1946 · S/N 1167
Back to AD 47-51-13