N5WM, cancelled Aug 1, 2005
Service difficulty reports · 119
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 = 'N5WM' AND deregistration_id = 'N5WM-2005-08-01' 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 = 'N5WM' AND deregistration_id = 'N5WM-2005-08-01' 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 P2EA00385Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND THE PASSENGER CABIN FLOORBEAM UPPER FLANGE AT BS 344 RBL 11 TO LBL 56 WL 208.5 WITH CORROSION. DISCOVERED TO BE OUT OF LIMITS 11/15/00. (M)SDR P2EA00390Frame · crackedSJO - DURING Q-CHECK, FOUND PASSENGER CABIN FRAME AT BS 360 BETWEEN STRINGER 14-15R WITH CRACK, LENGTH 1 INCH, WIDTH .002 INCH. REPAIRED PASSENGER CABIN FRAME AT BS 360 BETWEEN STRINGER 14-15R IAW BOEING SRM 53-10-4 FIG 10. (M)SDR P2EA00391Floor Support · crackedSJO - DURING Q-CHECK, FOUND THE PASSENGER CABIN AT BS 345 BL 0 WL 208.5 WITH CRACKED FLOOR SUPPORT INTERCOSTAL, LENGTH .25 INCH, WIDTH .003 INCH. REPAIRED THE PASSENGER CABIN AT BS 345 BL 0 WL 208.5 WITH CRACKED FLOOR SUPPORT INTERCOSTAL IAW BOEING SRM 51-40-SDR P2EA00392Frame · dentedSJO - DURING Q-CHECK, FOUND THE AFT CARGO COMPARTMENT FRAME BETWEEN STRINGER 24-25L BS 727A WITH DENT, LENGTH 2 INCH, WIDTH 1 INCH, DEPTH .125 INCH. REPAIRED THE AFT CARGO COMPARTMENT FRAME BETWEEN STRINGER 24-25L BS 727A IAW BOEING SRM 51-40-3 FIG 1. (M)SDR P2EA00344Channel · crackedSJO - DURING Q-CHECK, FOUND THE PASSENGER CABIN AT BS 807 RBL 18 WL 203 WITH CRACKED CHANNEL. (M)SDR P2EA00345Intercostal · crackedSJO - DURING Q-CHECK, FOUND THE PASSENGER CABIN AT BS 345 BL 0 WL 208.5 WITH CRACKED FLOOR SUPPORT INTERCOSTAL. (M)SDR P2EA00346Angle · crackedSJO - DURING Q-CHECK, FOUND THE PASSENGER CABIN AT BS 500B THROUGH 520 BL 0 WL 208 WITH CRACKED FLOOR INTERCOSTAL ANGLE. (M)SDR P2EA00347Channel · crackedSJO - DURING Q-CHECK, FOUND AFT CARGO COMPARTMENT AT BS 727-787 RBL 22 WITH CRACKED CHANNEL. (M)SDR P2EA00348Frame · crackedSJO - DURING Q-CHECK, FOUND PASSENGER CABIN FRAME AT BS 460 BETWEEN STRINGER 13-14L WITH CRACK. (M)SDR P2EA00394Frame · crackedSJO - DURING Q-CHECK, FOUND PASSENGER CABIN FRAME AT BS 460 BETWEEN STRINGER 13-14L WITH CRACK, LENGTH 1.5 INCH, .002 INCH. REPAIRED PASSENGER CABIN FRAME AT BS 460 BETWEEN STRINGER 13-14L IAW BOEING SRM 51-40-3 FIG 1. (M)SDR P2EA00350Frame · crackedSJO - DURING Q-CHECK, FOUND PASSENGER CABIN FRAME INTERNAL FLANGE AT BS 460 BETWEEN STRINGER 13-14R CRACKED. (M)SDR P2EA00349Frame · crackedSJO - DURING Q-CHECK, FOUND PASSENGER CABIN FRAME AT BS 360 BETWEEN STRINGER 14-15R WITH CRACK. (M)SDR P2EA00351Frame · crackedSJO - DURING Q-CHECK, FOUND PASSENGER CABIN FRAME AT BS 400 BETWEEN STRINGER 13-14R CRACKED. (M)SDR P2EA00352Intercostal · crackedSJO - DURING Q-CHECK, FOUND THE AFT CARGO COMPARTMENT AT BS 727 WL 176.1 LBL 14 INTERCOSTAL CRACKED. (M)SDR P2EA00353Angle · crackedSJO - DURING Q-CHECK, FOUND THE RIGHT WING AUXILIARY SPAR AREA UPPER FIXED PANEL SUPPORT ANGLE AT RSS 159 CRACKED. (M)SDR P2EA00368Frame · dentedSJO - DURING Q-CHECK, FOUND THE AFT CARGO COMPARTMENT FRAME BETWEEN STRINGER 24-25L BS 727A WITH DENT. (M)SDR P2EA00360Floor Support · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN FLOOR SUPPORT STRAP BETWEEN BS 312 - BS 328 LBL 11 WL 208.5 WITH CORROSION. L = 10.00 INCHES. W = 1.50 INCHES. D = 0.040 INCH. REPLACED THE CABIN FLOOR SUPPORT STRAP BETWEEN BS 312 - BS 328 LBL 11 WL 208.5 IAW BOEING SSDR P2EA00361Floor Support · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN FLOOR SUPPORT STIFFENER BETWEEN BS 328 - BS 344 LBL 11 WL 208.5 WITH CORROSION. L = 10.0 INCHES. W = 1.509 INCH. D = 0.040 INCH. REPLACED THE CABIN FLOOR SUPPORT STIFFENER BETWEEN BS 328 - BS 344 LBL 11 WL 208.5 IAW BOSDR P2EA00367Channel · corrodedSJO - DURING Q-CHECK, FOUND THE AFT CARGO COMPARTMENT CHANNEL BETWEEN BS 727 TO BS 847 LBL 22 WITH CORROSION OUT OF LIMITS. L = 80.00 INCHES. W = 2.00 INCHES. L = 0.040 INCH. REPLACED THE AFT CARGO COMPARTMENT CHANNEL BETWEEN BS 727 TO BS 847 LBL 22 IAW 51SDR P2EA00371Strap · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN FLOOR SUPPORT STRAP FROM BS 287 - BS 296.6 RBL 53 WL 209 WITH CORROSION OUT OF LIMITS. L = 3.00 INCHES. W = 1.50 INCHES. D = 0.040 INCH. REPLACED THE CABIN FLOOR SUPPORT STRAP FROM BS 287 - BS 296.6 RBL 53 WL 209 IAW BSDR P2EA00372Channel · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN FLOOR CHANNEL FROM BS 302 - BS 305.5 BETWEEN LBL 36 AND LBL 47 WITH CORROSION OUT OF LIMITS. L = 2.00 INCHES. W = 1.00 INCH. D = 0.025 INCH. REPLACED THE CABIN FLOOR CHANNEL FROM BS 302 - BS 305.5 BETWEEN LBL 36 AND LBSDR P2EA00373Seat Track · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN SEAT TRACK FROM BS 328 - BS 360 RBL 22.5 WL 208.5 WITH CORROSION OUT OF LIMITS. L = 3.00 INCHES. W = 2.00 INCHES. D = 0.050 INCH. REPAIRED THE CABIN SEAT TRACK FROM BS 328 - BS 360 RBL 22.5 WL 208.5 IAW BOEING SRM 53-1SDR P2EA00374Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND THE CABIN FLOOR BEAM UPPER FLANGE AT BS 294.5 BETWEEN RBL 12 AND RBL 45 WL 208.5 WITH CORROSION OUT OF LIMITS. L = 40.00 INCHES. W = 2.00 INCHES. D = 0.074 INCH. REPAIRED THE CABIN FLOOR BEAM UPPER FLANGE AT BS 294.5 BETWEEN RBLSDR P2EA00238Structure · bird strikePIT - FLT 408 - ON POST FLIGHT WALKAROUND, NOTED BIRD STRIKE ON NR 2 ENIGNE INLET AND ON NR 3 SLAT INBOARD SIDE. PERFORMED BIRD STRIKE INSPECTION PER MM 05-51-201. NO DAMAGE OR OTHER DEFECTS NOTED. ENGINE RUN PERFORMED AND TAKEOFF POWER ACHIEVED. OK TO CONSDR P2EA00233Wire · exposedMDW - FLT 323 - DURING DESCENT INTO MDW WHEEL WELL FIRE LIGHT AND FIRE WARNING BELL ILLUMINATED WHEN GEAR DOWN AND SELECTED. DECLARED AN EMERGENCY AND LANDED. INSPECTED WHEEL WELL FIRE LOOP AND WIRING, FOUND AN EXPOSED WIRE. REPAIRED WIRE IAW WPM 20-10-13 PSDR P2EA00198Switch · out of adjFLT 305 - MCI - IN FLIGHT AT 500 FEET AGL, THE FORWARD ENTRY DOOR WARNING LIGHT CAME ON AND STAYED ON INTO GATE. ADJUSTED FORWARD ENTRY DOOR WARNING LIGHT SWITCH IAW BOEING MM 52-11-0 OPERATION CHECKED GOOD. (M)SDR P2EA00071Skin · crackedMCI - DURING POST-FLIGHT WALK AROUND, MAINTENANCE FOUND 1.50 INCH CRACK IN FUSELAGE SKIN AFT ON E/E DOOR AT 6:00 O''CLOCK POSITION. REPAIRED SKIN PER BOEING SB 737-53-1117 AND BAC SRM 53-30-2, FIG 3. (X)SDR P2EA00070Gearbox · leakingMCI - FLT 588 - EMERGENCY DECLARED, LANDING UNEVENTFUL. LOST OIL QTY ON NR 1 ENGINE FOLLOWED BY LOSS OF OIL PRESSURE. SHUT NR 1 ENGINE DOWN INFLIGHT. CREW REPORTED NR 1 ENGINE INDCIATIONS AT SHUTDOWN, PRESS 38, QTY 0, TEMP 105. WINDMILL TIME FROM SHUTDOWN SDR P2EA00068Skin · crackedMCI - MAINTENANCE REPORTS POSSIBLE SKIN CRACK BELOW L-2 DOOR THRESHOLD, STATION 950, STRINGER 21 LEFT. PERFORMED DYE CHECK, CONFIRMED CRACK. REPAIRED PER SRM 53-30-3, FIG 6. (M)SDR P2EA99331Rib · crackedSJO - DURING C-CHECK, RIB CRACKED AT BS 537, WL 156 INCH BETWEEN LBL 52 INCH AND LBL 62 INCH, INSIDE THE LEFT FORWARD WING TO BODY FAIRING. FABRICATED ANGLE IAW COOPESA EO COO-3-53-663-99 AND REPAIRED RIB IAW SERVICE BULLETIN 737-53-1098 PART III FIG 3, REVISSDR P2EA99329Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM LOWER CHORD CRACKED AT BS 707, BL 0 AND WL 202. REPAIRED FLOORBEAM LOWER CHORD FROM BS 700 TO BS 713 IAW COOPESA EO NR COO-3-57-643-99, DATED 11/11/99. (M)SDR P2EA99328Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM LOWER CHORD CRACKED AT BS 695, LBL 45.5 AND WL 202. REPAIRED FLOORBEAM LOWER CHORD FROM BS 688.5 TO BS 700 IAW COOPESA EO NR COO-3-57-643-99, DATED 11/11/99. (M)SDR P2EA99327Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM LOWER CHORD CRACKED AT BS 674, LBL 45.5 AND WL 202. REPAIRED FLOORBEAM LOWER CHORD FROM BS 668 TO BS 681 IAW COOPESA EO NR COO-3-57-643-99, DATED 11/11/99. (M)SDR P2EA99326Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM LOWER CHORD CRACKED AT BS 706, LBL 24.5 INCH AND WL 202 INCH. REPAIRED FLOORBEAM LOWER CHORD FROM BS 698 TO BS 714 IAW COOPESA EO NR COO-3-57-643-99, DATED 11/11/99. (M)SDR P2EA99325Floorbeam · crackedSJO - FLOORBEAM LOWER CHORD CRACKED AT BS 706, RBL 24.5 INCH AND WL 202 INCH. REPAIRED FLOORBEAM LOWER CHORD FROM BS 701 TO BS 712.5 IAW COOPESA EO NR COO-3-57-643-99, DATED 11/11/99. (M)SDR P2EA99324Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM LOWER CHORD CRACKED AT BS 695, RBL 45.5 INCH AND WL 202 INCH. REPAIRED FLOORBEAM LOWER CHORD FROM BS 689.5 TO BS 701.5. (M)SDR P2EA99323Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM LOWER CHORD CRACKED AT BS 673, RBL 45.5 INCH AND WL 20 INCH. REPAIRED FLOORBEAM LOWER CHORD FROM BS 667.5 TO BS 683. (M)SDR P2EA99321Rib · crackedSJO - DURING C-CHECK, RIB CRACKED AT BS 695, LBL 45.5 AND WL 206 INCH. FABRICATED WEB IAW SRM 51-20-2 AND INSTALLED IAW 51-10-1 PAGE 5. (M)SDR P2EA99320Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM CRACKED AT BS 707, BL 0 AND WL 204. REPAIRED FLOORBEAM FROM BS 698 AND BS 717 IAW SERVICE BULLETIN 737-57-1210 PART III FIG 5, DATED APRIL 4, 1999. REPAIRED IN CONJUNCTION WITH NON-ROUTINE 697. (M)SDR P2EA99319Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM WEB CRACKED AT BS 712, BL 0 AND WL 204 INCH. REPAIRED FLOORBEAM FROM BS 698 AND BS 717 IAW SERVICE BULLETIN 737-57-1210 PART III FIG 5. REPAIRED IN CONJUNCTION WITH NON-ROUTINE 700. (M)SDR P2EA99318Floorbeam · crackedSJO - DUIRNG C-CHECK, FLOORBEAM LOWER CHORD CRACKED AT BS 727, WL 202 INCH AND LBL 24.5 INCH. REPAIRED FLOORBEAM LOWER CHORD FROM BS 721.5 TO BS 738.5 IAW SERVICE BULLETIN 737-57-1210, PART III FIG 7, DATED APRIL 4, 1991. (M)SDR P2EA99317Floorbeam · crackedDURING C-CHECK, FLOORBEAM LOWER CHORD CRACKED AT BS 726, BL 0 AND WL 202 INCH. REPAIRED FLOORBEAM LOWER CHORD FROM BS 721 TO BS 738 IAW SB 737-57-1210, PART III FIG 7, DATED APRIL 4, 1991. (M)SDR P2EA99316Floorbeam · crackedSJO - DURING C-CHECK, FLOORBEAM CRACKED AT BS 727, WL 202 INCH AND RBL 24.5. REPAIRED FLOORBEAM BETWEEN BS 721 AND BS 737 IAW SERVICE BULLETIN 737-57-1210, PART III FIG 7, DATED APRIL 4, 1991. (M)SDR P2EA99315Fitting · crackedSJO - DURING C-CHECK, FITTING AT BS 727, BL 0, WL 202 INCH CRACKED. REPLACED FITTING IAW SRM 51-10-1. (M)SDR P2EA99330Skin · corrodedSJO - DURING C-CHECK, SPOILER NR 8, P/N 65-46451-51 DELAMINATED AND FITTING IN SPOILER CORRODED. FABRICATED FITTING IAW COOPESA EO COO-3-57-657-99, DATED 11/16/99 AND REPAIRED SPOILER IAW COOPESA EO COO-CMP-3-57-649-99, DATED 11/13/99 SPOILER REMOVED AND REPLSDR P2EA99322Beam · crackedSJO - DURING C-CHECK, PRESSURE DECK LOWER BEAM IN LEFT WHEEL WELL CRACKED AT BS 704, LBL 30 INCH AND L 0. FABRICATED BEAM USING EXTRUSION AND 10140-2002 IAW SRM 51-20-1 AND INSTALLED IAW SRM 51-30-2. (M)SDR P2EA99313Fasteners · wrong partSJO - DURING C-CHECK, NR 6 SLAT REPAIRED WITH TEMPORARY FASTENERS. REPAIRED IAW SRM 57-50-3 FIG 4. (M)SDR P2EA99314Beam · crackedSJO - DURING C-CHECK, LEFT WHEEL WELL AT BS 726, WL 192 LBL 66 INCH STRINGER 18A SHEAR BEAM CRACKED. FABRICATED SHEAR BEAM IAW SRM 51-20-1 AND REPLACED SHEAR BEAM IAW SRM 51-10-1. (M)SDR P2EA99310Stringer · corrodedSJO - DURING C-CHECK, SKIN AT BS 980, STRINGER 27R BULGING. REPAIRED STRINGER 27R FROM BS 986.5 TO 969 IAW SRM 53-10-03 FIG 1. (M)SDR P2EA99266Switch · out of adjustMCI - FLT 416 - NO EMERGENCY DECLARED, LANDING UNEVENTFUL. WITH THE GEAR UP AND THE FLAPS UP, GEAR WARNING HORN SOUNDS (INTERMITTENTLY) WHEN THE THROTTLES ARE REDUCED TO IDLE. ADJUSTED FLAP TAKEOFF WARNING SWITCH PER MM 31-26-23. OPS CHECK OK PER MM 31-26-1
Back to N5WM, cancelled Aug 1, 2005