N9303K, cancelled Apr 4, 2008
Service difficulty reports · 32
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N9303K' AND deregistration_id = 'N9303K-2008-04-04' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N9303K' AND deregistration_id = 'N9303K-2008-04-04' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR ZW0A0103701Battery PackTHE EGRESS LIGHTS WERE OUT FROM STA 982 TO 1200, AND AFT OF THE OVERWING EMERGENCY EXIT. REPLACED THE BATTERY PACK AT STATIONS 982, 991, AND 1057. CHECK-C 12-24-00 STL. --CLOSED-SDR TWAA0100904Relay · odorAFTER TAKEOFF SEVERAL CIRCUIT BREAKERS POPPED ON THE RT AC BUS, INCLUDING THE RECIRCULATION FAN AND SEVERAL FUEL BOOST PUMPS. THERE WAS ALSO AN ODOR. FLIGHT RETURNED TO STL. NOTHING WAS FOUND AFTER MANY ELECTRICAL CHECKS. REPLACED THE RT GEN POWER RELAY. SDR TWAA0100701Power Supply · malfunctionedTHE EGRESS LIGHTS CAME ON IN FLIGHT FROM ROW 15 TO 25. REPLACED THE POWER SUPPLY. CHECK-C 12-24-2000.SDR TWAA0101019Longeron · crackedDURING CHECK-C MAINT, LONGERON 2R WAS CRACKED AT STA 1209. REPAIRED CRACKED LONGERON 2R AT STA 1209 PER SRM 53-02, FIG 18.SDR TWAA9913202Power Supply · inopTHE EMERGENCY LIGHTS WERE INOPERATIVE IN THE AFT TAIL CONE AREA. REPLACED THE POWER SUPPLY. CHECK-C 11-25-98 MCI.SDR TWAA9912501Bulb · failedEMERGENCY LIGHTS IN AFT STAIRS INOPERATIVE. REPLACED BULB. CHECK C 11/25/98 MCI.SDR TWAA9901105Retract Mech · iced upTHE LANDING GEAR HANDLE WAS DIFFICULT TO MOVE TO THE DOWN POSITION. REQUIRED TWO HANDS AND SOME FORCE. MAINTENANCE PERFORMED NORMAL AND EMERGENCY GEAR EXTENSION AND FOUND NORMAL. CHECKED CABLE RUNS IN ELECTRONIC COMPT AND FOUND NORMAL. POSSIBLE ICE AFTER HESDR TWAA9819007Seat Track · corrodedDURING OP 15 MAINT CHECK, FOUND CORROSION REMOVAL MATERIAL LOSS AT LT O/B CHAIR TRACK LBL 51, STA 1130 TO 1133. REMOVED DAMAGED PART AND RE-INSTALLED NEW PART PER TWA STD PROCESS MANUAL 6-70-01, PG 3 ITEM B.SDR TWAA9818005Floor Track · corrodedDURING OP 15 MAINT CHECK, FOUND CORROSION ON CABIN FLOOR TRACK AT LBL 55, STA 1240 TO 1244. REPLACED TRACK WITH NEW TRACK MFG C03580-1. INSTALLED NEW FLOOR TRACK WITH SAME FASTENERS PER SPM 6-70-01 PAGE 3, AND 6-30-07, PG 1 AND 2.SDR TWAA9818004Skin · wrinkledDURING OP 15 MAINT CHECK, FOUND FUSELAGE SKIN WRINKLED AT STA 409, LONGERON 29R TO 30R. REPAIRED PER ARA 15743.SDR TWAA9818003Skin · dentedDURING OP 15 MAINT CHECK, FOUND SIX INCH BY 12 INCH BY 0.070 INCH DENT IN FUSELAGE SKIN AT STA 385 TO 391, LONGERON 29L TO 29R. REPAIRED PER ARA 15743.SDR TWAA9818001Floor Track · corrodedDURING OP 15 MAINT CHECK, FOUND CORROSION ON CABIN FLOOR TRACK AT LBL 55, STA 1193 TO 1203. REPLACED TRACK WITH NEW USING MFG C0358-1. INSTALLED SAME FASTENERS AS ORIGINAL PER SPM 6-70-01 PG 3 AND 6-30-07 PG 1 AND 2.SDR TWAA9813205Battery Pack · dischargedDURING MAINT FOUND FWD CABIN EGRESS LIGHTS INOP. REPLACED BATTERY PACK. CHECK-C 11-8-97 MCI.SDR TWAA9813204Battery Pack · dischargedDURING MAINT FOUND EMERGENCY OVERWING EXIT LIGHTS INOP. REPLACED BATTERY PACK AND POWER SUPPLY. BATTERY PACK E02899-1 AND POWER SUPPLY 33000794-05. CHECK-C 11-8-97 MCI.SDR TWAA9810708Frame · damagedJFK - THE FUSELAGE WAS DAMAGED AT FS 313, FORMER BETWEEN LONGERON 21 AND LONGERON 22R. DAMAGED AREA 6 INCHES WIDE BY 15 INCHES LONG. INSTALLED CLASS 2 REPAIR PER MD80 SRM 53-04, PG 47, FIG 12B SHEET 8. CHECK-C 11-8-97 MCI. ACFT TT: 35,201 HOURS. ACFT TC:SDR TWAA9778001Oven · failedMCI - FLT 427 - DURING CRUISE AFT GALLEY OVEN EMITTED SMOKE. REMOVED AND REPLACED OVEN, MFG PN 8203-11-0000, MANUFACTURED BY BUDERUS SELL CORPORATION. OPS CHECK NORMAL. CHECK C - 11-20-96 - JFK. (X)SDR 96ZZZM47Fan · failedSTL - FLT NR 202 - DURING CRUISE, THERE WAS AN ELECTRICAL SMELL COMING FROM THE RECIRCULATING FAN, P/N 605457-7 TWPN 12801. CIRCUIT BREAKER PULLED AND PLACARDED. DECEMBER 24, 1995, MSP REPLACED RECIRCULATION FAN. OPERATIONS CHECK NORMAL.SDR 96ZZZM247Tiedown Track · corrodedMCI - DURING OP-16, FOUND CORROSION IN LEFT TIEDOWN TRACK, STATION 1079 TO STATION 1109. REPAIRED PER SRM 53-05, FIGURE 4G AND ARA 9859.SDR 96ZZZM245Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR TRACK, STATION 160 TO STATION 200, RBL 53. REPLACED TRACK PER SSRM 51-10-01.SDR 96ZZZM237Floor Panel · corrodedMCI - DURING OP-16, FOUND CABIN FLOOR PANEL CORROSION, STATION 1305 TO STATION 1309. REPLACED FLOOR PAN PER SRM 51-10-01.SDR 96ZZZM236Floor Beam · corrodedMCI - DURING OP-16, FOUND CORROSION AT FLOOR BEAM, LEFT AFT LAVATORY FORWARD BULKHEAD LOWER END. REPAIRED PER SRM 53-01, FIGURE 4, SHEET 3.SDR 96ZZZM235Floor Support · corrodedMCI - DURING OP-16, FOUND CORROSION ON RIGHT FLOOR SUPPORT, FS 1155. INSTALLED NEW FLOOR SUPPORT PER SRM 51-01, PAGE 1C AND TWA STANDARD PRACTICES.SDR 96ZZZM234Support Beam · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR PANEL SUPPORT BEAM BL, FS 1155. INSTALLED NEW BEAM PER SRM 51-01, PAGE 1C AND TWA STANDARD PRACTICES.SDR 96ZZZM233Blkhd Support · corrodedMCI - DURING OP-16, FOUND CORROSION ON BULKHEAD SUPPORT MEMBER, FS 1320, LBL 25L TO LBL 31L. REPAIRED PER SRM 51-01, PAGE 1C AND TWA STANDARD PRACTICES. (M)SDR 96ZZZM232Frame · corrodedMCI - DURING OP-16, FOUND FORMER FRAME CORROSION BETWEEN LONGERONS 29L TO 29R, FS 1322. REPAIRED PER SRM 53-03, PAGE 4E AND SSRM 51-40-501.SDR 96ZZZM231Hold Down Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON 'E' GALLEY AFT INBOARD HOLD DOWN TRACK, STATION 1302 TO STATION 1281. REPLACED TRACK PER SRM 53-03, PAGE 10G.SDR 96ZZZM230Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR TRACK FORWARD OF AFT END OF TRACK AT SCREWS, LBL 36, STATION 1136. REMOVED CORROSION PER SRM 51-10-3, AND REPLACED TRACK PER SRM 51-10-1C.SDR 96ZZZM226Floor Track · corrodedMCI - DURING OP-16, FOUND CORROSION ON FLOOR TRACK NR 3, RBL 20, STATION 200-240. REPLACED TRACK PER SRM 53-05, PAGE 10G AND SRM 51-01, ITEM C.SDR 96ZZZM225Skin · corrodedMCI - DURING OP-16, FOUND CORROSION ON FUSELAGE SKIN BELOW AFT CARGO BIN DOORWAY UNDER COVER PLATE, STATION 1155-1212. REMOVED CORROSION PER SRM 51-10-3.SDR 96ZZZM224Floor Beam · corrodedMCI - DURING OP-16, FOUND FLOOR BEAM CORROSION BETWEEN FLOOR TRACKS, FS 1211. REPAIRED PER SRM 51-01, PAGE 1 AND TWA STANDARDS PRACTICES.SDR 96ZZZM223Skin · corrodedMCI - DURING OP-16, FOUND LOWER FUSELAGE SKIN CORROSION, STATION 775 TO 827, RB 273. REPAIRED EPR SRM 53-04, PAGE 321.SDR 96ZZZM222Floor Beam · corrodedMCI - DURING OP-16, FOUND FLOOR BEAM CORROSION, FS 1309, LBL 45. REMOVED CORROSION PER SRM 51-10-3, REPAIRED BEAM PER SRM 53-05, FIGURE 20A.
Back to N9303K, cancelled Apr 4, 2008