Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASAA9940042Support · corrodedPHX - DURING SCHEDULED SI, THE AFT CABIN UPPER SURFACE FLOOR SUPPORT BETWEEN STATION 947-967 LBL 24 WAS FOUND TO BE CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-40-01. (M)SDR ASAA9940041Support · corrodedPHX - DURING SCHEDULED SI, THE FLOOR SUPPORT AT BS 334 RBL 54 WAS FOUND TO BE CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-30-02. (M)SDR ASAA9940040Support · corrodedPHX - DURING SCHEDULED SI, THE FORWARD CABIN UPPER SURFACE FLOOR SUPPORT AT STATION 312-328 LBL 13 WAS FOUND TO BE CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-30-02 AND 51-40-02. (M)SDR ASAA9940039Skin · wornPHX - DURING SCHEDULED SI, THE LEFT WING OUTBOARD T/E MIDFLAP WAS FOUND TO BE WORN AT THE LEADING EDGE. REPAIRED PER EA 5750-01311. (M)SDR ASAA9940038Skin · dentedPHX - DURING SCHEDULED SI, THE LEFT WING T/E INBOARD FOREFLAP LOWER SURFACE WAS FOUND TO HAVE THREE DENTS. REPAIRED PER SRM 57-53-02 AND SRM 51-70-10 REPAIR NR 20. (M)SDR ASAA9940037Seat Track · corrodedPHX - DURING SCHEDULED SI, FOUND CORROSION ON THE RIGHT OUTBOARD SEAT TRACK AT STATION 480-500A. REPLACED SEAT TRACK PER SRM 53-30-52. (M)SDR ASAA9940036Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE AFT CABIN UPPER SURFACE FLOORBEAM AT STATION 987 LBL 36 - RBL 43 WAS FOUND TO BE CORRODED. REPAIRED FLOORBEAM PER EA 5310-01641. (M)SDR ASAA9940035Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE FORWARD CABIN UPPER SURFACE FLOORBEAM AT STATION 344 LBL 14-55 WAS FOUND TO BE CORRODED. REPLACED UPPER CHORD FLOORBEAM PER SRM 53-10-51. (M)SDR ASAA9940034Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE FORWARD CABIN UPPER SURFACE FLOORBEAM AT STATION 312 LBL 13 - RBL 10 WAS FOUND TO BE CORRODED. REPLACED T-CHORD PER SRM 53-10-51. (M)SDR ASAA9940033Support · corrodedPHX - DURING SCHEDULED SI, THE AFT CARGO COMPARTMENT FLOOR SUPPORT AT STATION 947 BETWEEN STRINGER 25L AND 26L WAS FOUND TO BE CORRODED. REPAIRED SECTION PER 53-00-53. (M)SDR ASAA9940032Support · corrodedPHX - DURING SCHEDULED SI, THE AFT CARGO COMPARTMENT FLOOR SUPPORT AT STATION 947 STRINGER 26R WAS FOUND TO BE CORRODED. REPAIRED SECTION PER 53-00-53. (M)SDR ASAA9940031Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE UPPER SURFACE OF THE FLOORBEAM AT STATION 1016 LBL 29 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-00-51. (M)SDR ASAA9940030Floorbeam · corrodedPHX - DURING SCHEDULED SI, THE FLOORBEAM AT STATION 360 RBL 20-30 WAS FOUND TO BE CORRODED. REPLACED FLOORBEAM SECTION PER SRM 53-00-51. (M)SDR ASAA9940029Seat Track · corrodedPHX - DURING SCHEDULED SI, THE RIGHT INBOARD SEAT TRACK FROM STATION 360-500E WAS FOUND TO BE CORRODED. REPLACED SEAT TRACK PER SRM 53-00-52. (M)SDR ASAA9940028Support · corrodedPHX - DURING SCHEDULED SI, THE AFT CARGO COMPARTMENT FLOOR SUPPORT AT STATION 867-947 STRINGER 25R WAS CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-40-02 AND 53-60-53. (M)SDR ASAA9940027Support · corrodedPHX - DURING SCHEDULED SI, THE AFT CARGO COMPARTMENT FLOOR SUPPORT AT STATION 947-807 STRINGER 25L WAS CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-40-02 AND 53-60-53. (M)SDR ASAA9940026Support · corrodedPHX - DURING SCHEDULED SI, THE AFT CARGO COMPARTMENT FLOOR SUPPORT AT STATION 727B-807 STRINGER 25L WAS CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-40-02 AND 53-60-53. (M)SDR ASAA9940025Support · corrodedPHX - DURING SCHEDULED SI, THE AFT CARGO COMPARTMENT FLOOR SUPPORT AT STATION 727B-727E STRINGER 25L WAS CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-40-02 AND 53-60-53. (M)SDR ASAA9940024Support · corrodedPHX - DURING SCHEDULED SI, THE AFT CARGO COMPARTMENT FLOOR SUPPORT AT STATION 727C-769 STRINGER 25R WAS CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-40-02 AND 53-60-53. (M)SDR ASAA9940023Intercostal · corrodedPHX - DURING SCHEDULED SI, THE UPPER SURFACE OF THE INTERCOSTAL AT STATION 1016 RBL 27 WAS CORRODED. REPLACED STRAP PER SRM 51-40-02. (M)SDR ASAA9940022Support · corrodedPHX - DURING SCHEDULED SI, THE UPPER SURFACE OF THE FLOOR SUPPORT AT STATION 967-987 LBL 16 WAS CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-40-00. (M)SDR ASAA9940021Support · corrodedPHX - DURING SCHEDULED SI, THE FLOOR SUPPORT AT STATION 967-987 RBL 16 WAS CORRODED. REPLACED FLOOR SUPPORT PER SRM 51-40-00. (M)SDR ASAA9940020Support · corrodedPHX - DURING SCHEDULED SI, THE UPPER SURFACE SUPPORT AT STATION 328-344 LBL 13 WAS CORRODED. REPLACED SUPPORT PER SRM 51-40-2. (M)SDR ASAA9940019Support · corrodedPHX - DURING SCHEDULED SI, THE FLOOR SUPPORT AT BS 303-348 LBL 70.53 WAS FOUND TO BE CORRODED. REPLACED CHORD PER SRM 51-40-2. (M)SDR ASAA9940018Floorbeams · corrodedSEA - DURING SCHEDULED SI, FOUND CORROSION IN THE UPPER FLANGE OF THE CARGO FLOORBEAMS BETWEEN BS 727F AND 727G. REPAIRED PER EA 5310-01645. (M)SDR ASAA9940017Support · corrodedSEA - DURING SCHEDULED SI, THE FLOOR SUPPORT IN THE LOWER AFT CARGO COMPARTMENT AT BS 945 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5320-01358. (M)SDR ASAA9940016Web · gougedSEA - DURING SCHEDULED SI, GOUGES WERE FOUND IN THE SHEAR WEB ASSEMBLY UPPER SURFACE AT STATION 294-312 LBL 11. REPAIRED PER EA 5310-01644 AND BOEING TELEX ASA-SEA-99-0053RR. (M)SDR ASAA9940015Bracket · frettedSEA - DURING SCHEDULED SI, FRETTING WAS FOUND ON THE ANGLE BRACKET LOWER FUSELAGE STATION 727 RBL 10. REPAIRED PER EA 5320-01333. (M)SDR ASAA9940014Floorbeam · corrodedSEA - DURING SCHEDULED SI, THE UPPER FLANGE OF THE CARGO FLOORBEAM AT STATION 772 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01646. (M)SDR ASAA9940013Shroud · chafedSEA - DURING SCHEDULED SI, THE APU LOWER SHROUD WAS FOUND TO BE CHAFED ON THE FORWARD LEFT SIDE. REPAIRED PER EA 4910-01028. (M)SDR ASAA9940012Wire · disconnectedLAX - PRIOR TO FLIGHT 137 - CREW REPORTED THAT THE EMERGENCY EXIT TRACK LIGHTS WERE INOPERATIVE AT ROW 14. RECONNECTED WIRING TO LIGHTS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9940011Wire · disconnectedPDX - DURING MAINTENANCE CHECK, TWO FORWARD RED EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED LIGHTS/WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9940007Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE AFT 2 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940006Battery · dischargedSEA - DURING MAINTENANCE CHECK, THE AFT SECTION OF EMERGENCY FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. REPLACED THE RT AFT CHARGER AND BATTERY, LIGHTS OPERATED NORMALLY. REF: OPER CONTROL NR 99ZZZX741. (X)SDR 99ZZZX741Battery Charger · inoperativeSEA - DURING MAINTENANCE CHECK, THE AFT SECTION OF EMERGENCY FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. REPLACED THE RT AFT CHARGER AND BATTERY, LIGHTS OPERATED NORMALLY. REF: OPER CONTROL NR ASAA9940006.SDR ASAA9940005Wire · disconnectedSEA - DURING MAINTENANCE CHECK THE FORWARD TWO RED EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940004Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS AT ROWS 22-25 WERE FOUND INOPERATIVE. RECONNECTED WIRING/LIGHTS AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940003Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE FORWARD TWO AND AFT TWO EMERGENCY EXIT TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING/LIGHTS AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940002Snubber · inoperativePDX - PRIOR TO FLT 471, THE L1 DOOR WAS DIFFICULT TO CLOSE. REPLACED SNUBBER AND LUBRICATED PIVOT POINTS, DOOR OPERATED NORMALLY. ACFT TT: 17,769 HOURS. ACFT TC: 10,554. (X)SDR ASAA9940001Light · looseSEA - PRIOR TO FLT 468, TWO EACH RED EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE IN THE FIRST CLASS SECTION. CLEANED AND RESECURED TRACK AND THE LIGHTS OPERATED NORMALLY. (X)SDR ASAA9840120Clip · missingSNA - UPON ARRIVAL OF FLT 486, THE L1 DOOR COULD NOT BE OPENED. CONTRACT MAINTENANCE REPLACED MISSING C-CLIP ON THE UPPER ARM ASSEMBLY AND THE DOOR OPERATED NORMALLY. (M)SDR ASAA9840119Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE AFT TWO EMERGENCY EXIT FLOOR TRACK LIGHTS AND THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 22 THROUGH 25 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AT BOTH LOCATIONS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9840118Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE AFT TWO EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9840116Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE FORWARD TWO AND AFT TWO EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED BOTH THE FORWARD AND AFT LIGHTS/WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9840115Mechanism · lack of lubeLAX - PRIOR TO FLT 477 - THE L1 DOOR WOULD NOT CLOSE PROPERLY. CLEANED AND LUBRICATED ROLLER GUIDES AND LOCK ROLLERS, DOOR CLOSED AND LOCKED NORMALLY. (M)SDR ASAA9840114Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS FAILED TO TEST. REPLACED ALL BATTERY PACKS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9840112Clip · missingOAK - PRIOR TO FLIGHT 493 - THE L-1 DOOR WAS FOUND TO BE DIFFICULT TO OPEN. FOUND RETAINER CLIP MISSING FROM PIN ON THE UPPER HINGE CAUSING INTERFERENCE. REPLACED MISSING RETAINER CLIP AND DOOR OPERATED NORMALLY. (M)SDR ASAA9840111Wire · disconnectedPDX - DURING MAINTENANCE CHECK, TWO FORWARD EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9840110Wire · disconnectedPDX - DURING MAINTENANCE CHECK, TWO FORWARD EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9840107Wire · disconnectedPDX - DURING MAINTENANCE CHECK THE AFT EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING/LIGHTS AND LIGHT OPERATED NORMALLY. (M)
Back to Boeing 737-4Q8