Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2015052640004Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED, FASTENER HOLE LOCATED AT RSS 215.97+6.5. REPAIRED CHORD IAW EO & EA.SDR SWAA2015041338447Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 25R - 26R. R & R SHEAR TIE IAW SRM.SDR SWAA2015040738205Skin · corrodedSKIN CORRODED AT BS 727D+10, RBL 1. REPAIRED SKIN IAW ER & EA.SDR SWAA2015040738204Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20L - 21L. REPAIRED FRAME IAW ER & EA.SDR SWAA2015040738196Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 2L. R & R SPLICE IAW EA & SRM.SDR SWAA2015032637881Support Fitting · crackedVHF SUPPORT CLIP CRACKED AT BS 727E, BETWEEN LBL 2 TO RBL 2. R & R CLIP IAW SRM.SDR SWAA2015032437746Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 5L. R & R CLIP IAW SRM & DWG.SDR SWAA2015032437745Stiffener · crackedRIGHT WW GUSSET INBD UPPER HOLE STIFFENER CRACKED AT BS 663, RBL 6.15. R & R STIFFENER IAW SRM & DWG.SDR SWAA2015030537150Lug · brokenLEFT WING INBD NR 4 GND SPOILER ATTACH LUG BROKEN. R & R NR 4 GND SPOILER IAW AMM.SDR SWAA2015030437085Skin · delaminatedRIGHT WING OTBD AFT FLAP DELAMINATED ON LOWER & UPPER SKIN JUST OTBD OF NR 7. R & R AFT FLAP IAW MM.SDR SWAA2015040738203Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 907, STRINGER 19L. R & R SPLICE IAW SRM.SDR SWAA2015040138058Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 907, STRINGER 20L. R & R SPLICE IAW SRM.SDR SWAA2015040138057Stringer · corrodedSTRINGER CORRODED BETWEEN BS 967 - 1016, STRINGER 25L. R & R STRINGER IAW SRM.SDR SWAA2015032637884Floorbeam · corrodedAFT GALLEY FLOORBEAM CORRODED AT BS 967, RBL 25. REPAIRED CHORD IAW ER & EA.SDR SWAA2015032637883Floorbeam · corrodedAFT GALLEY FLOORBEAM UPPER T CHORD CORRODED AT BS 986.5, BETWEEN LBL 4 TO RBL 55. R & R T CHORD IAW SRM.SDR SWAA2015030637176Logic Card · defectiveAFTER RAISING GEAR HAD LT GEAR RED LIGHT WITH HANDLE IN UP POSITION. PUT HANDLE IN OFF POSITION & HAD RED & GREEN LT GEAR LIGHTS. RAN QRH, PUT HANDLE BACK IN UP POSITION & RED LT GEAR LIGHTS REMAINED ILLUMINATED. R & R LOGIC CARD 987 IAW MM.SDR SWAA2015030337050Casting · brokenLEFT WING INBD GND SPOILER OTBD HINGE CASTING BROKEN. R & R GND SPOILER IAW AMM.SDR SWAA2015040138056Angle · corrodedAFT CARGO BAY, BILGE AREA SPLICE ANGLE CORRODED AT BS 847, STRINGER 27R. REMOVED & REPLACED SPLICE ANGLE IAW SRM.SDR SWAA2015033037970Bracket · crackedFORWARD CARGO BILGE AFT SECTION BAFFLE BRACKET CRACKED AT BS 500C, BETWEEN STRINGER 26R - 25R. R & R BAFFLE BRACKET IAW SRM.SDR SWAA2015030237030Cover · looseEMERGENCY EXIT LIGHT COVER LOOSE. R & R FWD COVER IAW MM.SDR SWAA2015040838285Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD AFT END CRACKED AT BS 727B, LBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2015040738202Structure · crackedOUTBOARD CHORD CRACKED AT BS 727, STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2015040738201Structure · crackedOUTBOARD CHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2015040738189Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED CHORD IAW EA & ER.SDR SWAA2015032637882Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT GND AIR CONDITION DOOR CUT OUT AT FASTENER FWD RT CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2015030237032Lens · looseRIGHT OVERWING EMER EXIT SIGN LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2015030237031Skin · damagedLEFT WING INBD FORE FLAP DAMAGED ON UPPER SURFACE. R & R FORE FLAP IAW AMM.SDR SWAA2015030236999Battery · dischargedFORWARD FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2015030236989Charger · inoperativeRIGHT EMER LIGHT INOPERATIVE AT ROW 1. R & R LIGHT CHARGER ASSEMBLY IAW MM.SDR SWAA2015040238085Attach Bracket · crackedRIGHT WING TE NO STEP PANEL INBD ATTACH BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2015030237029Cover · crackedLEFT OF R1 DOOR GALLEY EMER EXIT COVER CRACKED. R & R LIGHT IAW AMM.SDR SWAA2015030236993Fuel Cap · separatedAIR TURN BACK, CREW REPORTS RT WING OVERWING FUEL CAP CAME OFF IN FLIGHT WITH APPROX 2500 LB RT MAIN FUEL QTY VENTED OVERBOARD. R & R RT MAIN TANK OVERWING FUEL CAP IAW MM.SDR SWAA2015042438880Angle · crackedRIGHT FWD WING TO BODY FAIRING CUT OUT STRUCTURE CRACKED, AFT OTBD CORNER FWD OF AIR CONDITION DOOR. R & R ANGLE ASSEMBLY IAW SRM & DWG.SDR SWAA2015041038377Support · crackedLEFT AIR CONDITION DOOR CUT OUT, FWD OTBD CORNER AIRING SUPPORT CRACKED. R & R SUPPORT IAW SRM & DWG.SDR SWAA2015033138011Repair · crackedR1 DOOR LOWER AFT REPAIR ON VERTICAL SIDE OF INTERNAL STRUCTURE FRAME CRACKED. R & R FRAME IAW DWG & SRM.SDR SWAA2015030237033Slide · looseL1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW AMM & MT.SDR SWAA2015022736969Slide · failedR1 DOOR EMER EVAC SLIDE FAILED OPERATION TEST. R & R SLIDE IAW MT.SDR SWAA2015022736961Cover · missingRIGHT OVERWING EMER EXIT DOOR LIGHT COVER MISSING. INSTALL COVER IAW SIP.SDR SWAA2015022736953Battery Pack · dischargedLEFT BULLNOSE EMER LIGHT INOPERATIVE BETWEEN ROW 14 TO 18. R & R BATTERY PACK IAW MM.SDR SWAA2015022736952Sign · looseRIGHT EMER EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2015022736951Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE ASSEMBLY IAW MT.SDR SWAA2015022636921Battery Pack · dischargedFORWARD CABIN EMER EXIT LIGHT FAULTY. R & R BATTERY PACK IAW AMM.SDR SWAA2015101244833Panel · crackedRIGHT WING PYLON, UPPER PANEL JUST AFT OF NR 58710R, CRACKED AT AFT INBD SIDE CUT OUT. REPAIRED PYLON IAW EA.SDR SWAA2015042738991Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CHANNEL CORRODED AT BS 772, LBL 7. REPAIRED CHANNEL IAW SRM & DWG.SDR SWAA2015042438916Fitting · crackedAFT CARGO DOOR, AFT END OF CROSSBEAM E INBD T CHORD CRACKED AT THE CTR FASTENER OF THE THREE MOST AFT FASTENERS. R & R DOOR IAW AMM.SDR SWAA2015042138740Shear Tie · corrodedAFT CARGO BAY SHEAR TIE CORRODED AT BS 747, BETWEEN STRINGER 26L - 27L. R & R SHEAR TIE IAW SRM.SDR SWAA2015041438500Floorbeam · corrodedAFT CARGO BAY FLOORBEAM ANGLE CORRODED AT BS 772, RBL 3. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2015040738200Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 727D+5, RBL 8. REPAIRED ANGLE IAW SRM.SDR SWAA2015040738199Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 727D+5, RBL 3. REPAIRED FLOORBEAM IAW EA.SDR SWAA2015040738195Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED ANGLE IAW EA.
Back to Boeing 737-3H4