Boeing 737-2X6C
Service difficulty reports · 1,351
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7372X6C' 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 aircraft_model_key = '7372X6C' 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 EE4Y100155Crossbeam · corroded((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT BL 0 BETWEEN B/ 986.5 AND B/S 1006, CROSS BEAM UPPER CHORD WITH CORROSION. (W/O Y10122, SUB JOB 2, ITEM 102).SDR EE4Y100154Floorbeam · corrodedUPPER FUSELAGE MAIN CARGO CABIN AT B/S 986.5 FLOORBEAM UPPER CHORD WITH CORROSION BETWEEN LBL 16 AND RBL 45. (W/O Y10122, SUB JOB 2, ITEM 100).SDR EE4Y100153Channel · cracked((EE4Y)) LOWER FUSELAGE AFT CARGO COMPARTMENT AT BSTA 847 STR 19R CHANNEL CRACKED. (W/O Y10122, SUB JOB 1, ITEM 135).SDR EE4Y100152Skin · cracked((EE4Y)) LOWER FUSELAGE AFT CARGO COMPARTMENT DOOR INNER SKIN CRACKED. (W/O Y 10122, SUB JOB 1, ITEM 95).SDR EE4Y100151Support · cracked((EE4Y)) LOWER FUSELAGE AFT CARGO DOOR CUT-OUT AT BSTA 793 FROM STR 22R TO 25R STOP FITTING INNER SUPPORT CRACKED. (WORK ORDER Y10122, SUB JOB 1, ITEM 84).SDR EE4Y100149Skin · cracked((EE4Y)) LOWER FUSELAGE FWD CARGO COMPARTMENT DOOR INNER SKIN AT BS 440 BETWEEN BEAM 2,3 WITH CRACK. (W/O Y10122, SUB JOB 1, ITEM 67).SDR EE4Y100150Stringer Clip · cracked((EE4Y) LOWER FUSELAGE AFT CARGO COMPARTMENT BSTA 727A STR 25L WITH CLIP CRACKED. (W/O Y10122, SUB JOB 1, ITEM 71).SDR EE4Y100148Skin · cracked((EE4Y)) RT WING FRONT SPAR SECTION, LEADING EDGE SKIN WITH CRACK AT WBL STA 280.76. ( W/O Y10122, SUB JOB 6, ITEM 16).SDR EE4Y100147Skin · cracked((EE4Y)) RT WING FRONT SPAR SECTION LEADING EDGE SKIN WITH CRACK AT WBL 405. (WORK ORDER Y10122, SUB JOB 6, ITEM 12).SDR EE4Y100146Skin · crackedLT WING L/E SKIN WITH CRACK AT WBL 384. (W/O Y10122, SUB JOB 5, ITEM 9).SDR EE4Y100144Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 787 STR 6R, STRINGER TIE CLIP WITH CRACKED. W/O Y10122, SUB JOB 2, ITEM 73.SDR EE4Y100143Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 787 STR 5R, STRINGER TIE CLIP WITH CRACK. W/O Y10122, SUB JOB 2, ITEM 73.SDR EE4Y100142Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 787 STR 3R, STRINGER TIE CLIP WITH CRACK. W/O Y10122, SUB JOB 2, ITEM 73.SDR EE4Y100141Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 767 STR 5R, STRINGER TIE CLIP WITH CRACK. W/O Y10122, SUB JOB 2, ITEM 72.SDR EE4Y100140Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 767 STR 6L, STRINGER TIE CLIP WITH CRACK. W/O Y10122, SUB JOB 2, ITEM 72.SDR EE4Y100139Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 747 STR 5R, STRINGER TIE CLIP WITH CRACK. W/O Y10122, SUB JOB 2, ITEM 71.SDR EE4Y100138Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 747 STR 5L, STRINGER TIE CLIP WITH CRACK. WORK ORDER Y10122, SUB JOB 2, ITEM 71.SDR EE4Y100137Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 747 STR 8L, STRINGER TIE CLIP WITH CRACK. W/O Y10122, SUB JOB 2, ITEM 71.SDR EE4Y100136Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 727B STR 7R, STRINGER TIE CLIP WITH CRACK. WORK ORDER Y10122, SUB JOB 2, ITEM 70.SDR EE4Y100135Stringer Clip · cracked((EE4Y) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 727B STR 5R, STRINGER TIE CLIP WITH CRACK. W/O Y10122, SUB JOB 2, ITEM 70.SDR EE4Y100134Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 727A STR 7R STRINGER TIE CLIP WITH CRACK. WO Y10122, SUB JOB 2, ITEM 69.SDR EE4Y100129Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 706 STR 10L STRINGER TIE CLIP CRACK. WORK ORDER Y10122, SUB JOB 2, ITEM 68.SDR EE4Y100128Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 685 STR 4R STRINGER TIE CLIP WITH CRACK. WORK ORDER Y10122, SUB JOB 2, ITEM 67.SDR EE4Y100127Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 616 STR 3R STRINGER TIE CLIP WITH CRACK. W/O Y10122, SUB JOB 2, ITEM 66.SDR EE4Y100126Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 460 STR 4R STRINGER TIE CLIP WITH CRACK. WORK ORDER Y10122, SUBJOB 2, ITEM 65.SDR EE4Y100133Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN B/S 440 STR 10R, STRINGER TIE CLIP WITH CRACK.SDR EE4Y100132Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 440 STR 4R, STRINGER TIE CLIP WITH CRACK.SDR EE4Y100125Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 440 STR 3, STRINGER TIE CLIPS WITH CRACKS.SDR EE4Y100131Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 420 STR 10, STRINGER TIE CLIP WITH CRACK.SDR EE4Y100124Stringer Clip · cracked((EE4Y)) UPPER FUSALAGE MAIN CARGO CABIN AT B/S 420 STR 5R, STRINGER TIE CLIPS WITH CRACK.SDR EE4Y100130Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AL B/S 400 STR 10R, STRINGER TIE CLIP WITH CRACK.SDR EE4Y100123Stringer Clip · cracked((EE4Y)) UPPER FUSELAGE MAIN CARGO CABIN AT B/S 400 STR 4R AND STR 10R STRINGER TIE CLIPS WITH CRACK.SDR EE4Y100120Attach Fitting · corroded((EE4Y)) LOWER FUSELAGE AFT CARGO COMPARTMENT AT BS 867, S26L CLIP WITH CORROSION.SDR EE4Y100100121Attach Fitting · cracked((EE4Y)) LOWER FUSELAGE AFT CARGO COMPARTMENT AT BS 727A, S25L WITH CRACK.SDR EE4Y100119Attach Fitting · corroded((EE4Y)) LOWER FUSELAGE AFT CARGO COMPARTMENT AT BSTA 867 LSTR 20 CLIP WITH CORROSION.SDR EE4Y100118Intercostal · cracked((EE4Y)) UPPER FUSELAGE CARGO CABIN B/S 360 STR 14 LT INTERCOSTAL WEB CRACKED.SDR EE4Y100116Intercostal · cracked((EE4Y)) UPPER FUSELAGE CARGO CABIN B/S 294.5 STRINGER 8 LT INTERCOSTAL ANGLE CRACKED.SDR EE4Y100115Intercostal · cracked((EE4Y)) UPPER FUSELAGE CARGO CABIN B/S 294.5 INTERCOSTALS CRACKED (2EA) AT STRINGER 11 AND 12 LT.SDR EE4Y100114Skin · canning((EE4Y)) LOWER EXTERNAL FUSELAGE AT B/S 360.5 BETWEEN STRINGERS 22R AND 23R SKIN WITH OIL CAN.SDR EE4Y100113Connector · brokenLOWER FUSELAGE FWD CARGO COMPARTMENT BATTERY POWER SUPPLY GROUND CONNECTION BROKEN.SDR EE4Y100112Duct · crackedLOWER FUSELAGE LT AIR CONDITIONING BAY, PRIMARY HEAT EXCHANGER EXHAUST DUCT CRACKED.SDR EE4Y100111Skin · delaminated((EE4Y)) LOWER FUSELAGE LT AIR CONDITIONING BAY DOOR INNER SKIN DELAMINATED AT STA 138.SDR EE4Y100110Support Angle · cracked((EE4Y)) LOWER FUSELAGE AT B/S 535.5 WL 144 LBL 45, WING TO BODY SUPPORT ANGLE WITH CRACK.SDR EE4Y100109Stringer · corrodedLWR FUSELAGE AFT CARGO COMPARTMENT AT B STA 767, STR 20L WITH CORROSION.SDR EE4Y100108Stringer · crackedEMPENNAGE TAIL COMPARTMENT FWD CORNER OF THE HORIZ STABILIZER CUTOUT AT THE UPPER HORIZ BEAM STRINGER S-5A RT CRACKED FROM BS 1138 TO BS 1142.SDR EE4Y100104Skin · crackedLOWER EXTERNAL FUSELAGE AT BS 306 STRINGER 18R SKIN WITH CRACK.SDR TSAA1053008Stringer · crackedDISCOVERED 1" CRACK DURING SCHEDULED INSP AT BS 492.4, S-22R (AFT SIDE OF FWD CARGO DOOR CUTOUT FWD END OF STRINGER). R & R STRINGER ASSY IAW SRM 53-10-3, FIG 1, APPLIED CORROSION INHIBITOR.SDR TSAA1034007Line · obstructedNON-ETOPS CARGO FLIGHT 28 HNL-OGG. ON TAKEOFF ROLL, CREW NOTED THE CAPTAIN’S AIRSPEED INDICATOR WAS INOP. CREW ABORTED TAKEOFF AT 80 KNOTS AND RETURNED TO THE CARGO RAMP WITHOUT FURTHER INCIDENT. MAINTENANCE FLUSHED OUT CAPT PITOT STATIC LINE AND REMOVED DESDR TSAA1027006Proximity Sensor · failedDURING CLIMB, AFTER THE FLAPS WERE RETRACTED, THE FLIGHT CREW NOTED THE LE FLAPS TRANSIT ANNUNCIATOR REMAINED ILLUMINATED. CREW ACCOMPLISHED THE QRH PROCEDURES AND ELECTED TO RETURN TO DEPARTURE. THE ACFT LANDED WITHOUT ANY FURTHER INCIDENT. MX R & R THE NRSDR TSAA1077005Skin · crackedDURING SCHEDULED 2B CK INSP A 3 CIRCUMFERENTIAL CRACK AT BS 540 BETWEEN S-0 AND S-1L WAS DISCOVERED. CONFIRMED WITH EDDY CURRENT INSP. MX ACTION CUTOUT DAMAGE CRACK, USE A .50" RADIUS CUT AT CORNERS, MAINTAINED 2DMINIMUM EDGE DISTANCE, LAY-OUT DOUBLER AND TRIP
Back to Boeing 737-2X6C