AD 76-20-07

Registered aircraft · 150

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:76-20-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-20-07')
  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.

N74282Santana 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 1505N74411Schmidt 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 1273N779WJenkins George Merritt · Wayne, PABuilt 1930 · S/N 617N77AYGould 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 1090
Back to AD 76-20-07