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 ASAA0640259Actuator · bypassingAFTER T/O GEAR HANDLE IN UP THEN OFF POSITION, LEFT GEAR DOOR AND LEFT GREEN GEAR LIGHT ILLUMINATED. DEFINITE YAW NOTICED. GEAR HANDLE PUT TO DOWN POSITION, ALL GEAR DOWN AND GREEN. REMOVED AND REPLACED LEFT MLG ACTUATOR AND LEFT MLG UPLOCK ACTUATOR.SDR ASAA0640234Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM. REPAIRED PER GOODRICH ER 06 1383 AND ASA EA 5310 02585.SDR ASAA0640229Floorbeam · corrodedFOUND TOP FLANGE OF FLOORBEAM CORRODED. REPAIRED PER SRM 51 70 11.SDR ASAA0640228Frame · crackedFOUND BSTA 907 STR 8L FRAME CRACKED. REPAIRED PER SRM 53 00 07.SDR ASAA0640225Floorbeam · corrodedFOUND TOP FLANGE OF FLOORBEAM AT BSTA 360 RBL 12 TO 25 WL 208 CORRODED. REPAIRED FLOORBEAM PER SRM 51 70 11.SDR ASAA0640221Sill · corrodedAFT SERVICE DOOR CREASE BEAM MOPSILL CORRODED. REMOVED AND REPLACED AFT SVC DOOR MOPSILL PER SRM 51 40 02.SDR ASAA0640207Web · crackedFOUND FLOOR WEB IS CRACKED. REMOVED AND REPLACED WEB.SDR ASAA0640222Guide · out of adjustL1 DOOR WILL NOT CLOSE FROM THE INSIDE UNLESS THE AFT PART OF THE DOOR IS PUSHED OUTBD WHILE CLOSING. REMOVED AND REPLACED BOTTOM GUIDE PLATE PER AMM 52 11 00 PG 407-408.SDR ASAA0640205Skin · gougedFOUND FWD CARGO DOOR SKIN GOUGED. REPAIRED FWD CARGO DOOR SKIN PER SRM 52 30 01.SDR ASAA0640206Skin · dentedFOUND AFT CARGO DOOR SKIN DENTED. RE SKINNED AFT CARGO DOOR.SDR ASAA0640199Crease Beam · corrodedFOUND CREASE BEAM CORRODED. REPLACED CREASE BEAM PER SRM 51 40 02.SDR ASAA0640202Bear Strap · corrodedAFT CARGO BAY BEAR STRAP DOUBLER IS CORRODED OUT OF LIMITS IN 3 LOCATIONS AT RBL 22 BETWEEN BS 767 & 787. REMOVED DAMAGED SECTION OF BEARSTRAP FABRICATED REPAIR STRAP FILLERS DOUBLERS TRIPLERS AND INSTALLED REPAIR PIECES IAW ASA EA 5330 02050.SDR ASAA0640201Skin · dentedFOUND FUSELAGE SKIN DENTED OUT OF LIMITS AT STA 800 UNDER AFT CARGO DOOR CUTOUT. REMOVED DAMAGED SECTION OF SKIN FABRICATED AND INSTALLED REPAIR STRAP FILLERS DOUBLERS AND TRIPLERS IAW ASA EA 5330 02050.SDR ASAA0640200Skin · dentedFOUND FUSELAGE SKIN DENTED OUT OF LIMITS AT BSTA 810 UNDER AFT CARGO DOOR CUTOUT. REMOVED DAMAGED SECTION OF SKIN FABRICATED AND INSTALLED REPAIR STRAP FILLERS DOUBLERS AND TRIPLERS PER ASA EA 5330 02050.SDR ASAA0640198Frame · chafedFOUND FRAME FLANGE CHAFED. REPAIRED PER SRM 51 70 11.SDR ASAA0640195Angle · corrodedCORROSION ON THRESHOLD Z ANGLE. REMOVED AND REPLACED PER SRM 51 40 02.SDR ASAA0640193Frame · crackedCRACKED FRAME AT BIN RAIL ATTACHMENT. REPAIRED PER SRM 53 00 07SDR ASAA0640194Stringer Clip · crackedCRACKED STRINGER CLIP. REMOVED AND REPLACED PER SRM 51 40 02.SDR ASAA0640184Strap · corrodedAFT CARGO BAY FLOOR STRIP IS CORRODED. CORRODED OUT OF LIMITS REMOVED AND INSTALLED NEW STRAP PER SRM 51 40 02.SDR ASAA0640192Shear Tie · corrodedCORRODED SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640191Shear Tie · corrodedCORRODED SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640190Shear Tie · corrodedCORRODED SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640189Shear Tie · corrodedCORRODED SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640188Shear Tie · corrodedCORROSION ON SHEAR TIE. REMOVED AND REPAIRED PER SRM 53 00 07.SDR ASAA0640187Crease Beam · corrodedCORROSION AT RT SIDE CREASE BEAM. REMOVED AND REPLACED OUT OF LIMITS CORRODED CREASE BEAM PER SRM 57 48 02.SDR ASAA0640186Stringer Clip · chafedSTRINGER CLIP CHAFED. REMOVED AND REPLACED STRINGER CLIP PER SRM 51 40 02.SDR ASAA0640185Skin · puncturedTHE RT INBD MIDFLAP T/E IS PUNCTURED ON THE LWR SURFACE. REMOVED DAMAGED AREAS OF LWR SKIN FABRICATED AND INSTALLED TWO FILLERS AND TWO DOUBLERS IAW SRM 51 70 10 PARA 7 8 12 15 AND 20.SDR ASAA0640183Floorbeam · corrodedCORROSION ON FLOOR BEAM AT PREVIOUS REPAIR. REPAIRED PER SRM 53 00 51 REPAIR 3.SDR ASAA0640169Tab · delaminatedRT ELEV TAB IS DELAMINATED ALONG THE TRAILING EDGE. REMOVED DAMAGED AREA OF TAB SURFACE PLY FABRICATED AND APPLIED ONE REPAIR PLY AND TWO SANDING PLIES IAW SRM 51 70 04 REPAIR 9. SANDED SMOOTH AND RESTORED FINISH.SDR ASAA0640167Crease Beam · corrodedLT CREASE BEAM SHEAR WEB IS CORRODED OUT OF LIMITS.SDR ASAA0640168Frame · corrodedFRAME CORRODED OUT OF LIMITS.SDR ASAA0640166Floorbeam · corrodedCORRODED FLOOR BEAM.SDR ASAA0640165Floorbeam · corrodedFLOOR BEAM FASTENER HOLES HAVE CORROSION.SDR ASAA0640164Stringer Clip · crackedSTRINGER CLIP CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM 51 40 02.SDR ASAA0640163Skin · dentedDENT IN FUSELAGE SKIN. REPAIRED PER SRM 53-80-01.SDR ASAA0640156Skin · corrodedCORROSION ON SKIN. REPAIRED PER EA 5390 02045 AND EA 5330 02048.SDR ASAA0640155Stringer · corrodedCORROSION ON STRINGER. REPAIRED PER EA 5310 02576.SDR ASAA0640154Channel · corrodedCORROSION AT BSTA 1016 PRESURE BULKHEAD LWR CTR CHANNEL JUST AFT OF BSTA 1016 FRAME CHORD. REPLACED LWR CTR CHANNELS PER EA 5310 02577.SDR ASAA0640153Skin · dentedDENT IN FUSELAGE SKIN. REPAIRED PER SRM 53 80 01.SDR ASAA0640157Skin · bulgedSKIN BULGING AROUND FASTENERS ALONG STRINGERS 26R AT BSTA 847 AND AT FASTENERS FOR BEAR STRAP BETWEEN STR 26R AND 27R. REPAIRED AREA IAW AS EA 5360 01052 ALONG STRINGERS 26R BSTA 847 AND BEAR STRAP BETWEEN STR 26R AND 27R.SDR ASAA0640152Skin · damagedDENT APPROX 42 INCHES AFT OF FWD LAV SERVICE DOOR FOUND TO BE CREASED. REPAIRED SKIN ON FUSELAGE PER SRM 53-00-01.SDR ASAA0640151Door Frame · corrodedAFT CARGO DOOR CUTOUT FRAME CORRODED. REMOVED AND REPLACED AFT CARGO DOOR CUTOUT FRAME PER SRM 53-00-7.SDR ASAA0640150Skin · debondedREPAIR ON UPPER SURFACE OF RT IB TE FLAP IS DISBONDED. REMOVED DAMAGED AREA FABRICATED AND INSTALLED FILLER AND DOUBLER PER SRM 51 70 10.SDR ASAA0640149Skin · dentedLT IB FORE FLAP DENTED 5 INCHES FROM TE AND 15 INCHES FROM IB END ON LWR SURFACE. REMOVED DAMAGED AREA FABRICATED AND INSTALLED FILLER AND DOUBLER PER SRM 51 70 10.SDR ASAA0640145Skin · dentedDENT FOUND ON LE OF RT STAB APPROX 2 INCHES FROM WING ROOT. REPAIRED PER SRM 55 10 01.SDR ASAA0640144Frame · corrodedFOUND CORROSION ON FRAME SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640142Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM AT PREVIOUS REPAIR. REPAIRED FLOORBEAM PER EA 5310 02564.SDR ASAA0640141Floorbeam · corrodedFOUND CORROSION ON BOTTOM OF 986.5 FLOORBEAM UPPER FLANGE. REPAIRED PER EA 5310 02565.SDR ASAA0640143Shear Tie · corrodedCORROSION ON FRAME SHEAR TIE. REPAIRED PER SRM 53 00 07 REPAIR 3.SDR ASAA0640148Repair · delaminatedNUMBER 5 SPOILER DELAMINATED ON LWR SURFACE AT EXISTING REPAIR. REMOVED DAMAGED AREA FABRICATED AND INSTALLED FILLER AND DOUBLER PER SRM 53 70 10 REPAIR 4.
Back to Boeing 737-4Q8