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 SWAA2013061217117Skin · delaminatedLEFT WING INBD T/E FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013070817984Frame · damagedFRAME OTBD T CHORD DAMAGED AT STATION 243, STRINGER 17L. R&R T CHORD IAW SRM & DRAWING.SDR SWAA2013070217842Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,4,5,6,10. REPAIRED SKIN IAW SWA EA.SDR SWAA2013070217841Skin · crackedRH BS 847+10 LOWER FORWARD WINDOW CORNER SKIN CUTOUT CRACKED AT HOLES 1,2,4,6,8. REPAIRED SKIN IAW SWA EA.SDR SWAA2013070217840Skin · crackedRT BS 727+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 1,5. REPAIRED SKIN IAW EA.SDR SWAA2013070117776Skin · crackedRT BS 887+10 UPPER AFT WINDOW CORNER SKIN CUTOUT CRACKED AT HOLES 1,2,3. REPAIRED SKIN IAW EA.SDR SWAA2013070117805Crease Beam · missingCREASE BEAM WEB MISSING BETWEEN STA 235 TO STA 243, STR 17L. INSTALLED WEB IAW SRM AND DWG.SDR SWAA2013062517578Skin · crackedRT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,11. REPAIRED SKIN IAW SB.SDR SWAA2013062417467Skin · crackedRT BS 867+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013062417466Skin · crackedRT BS 847+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLES 2,3,6. REPAIRED SKIN IAW SB.SDR SWAA2013062417465Skin · crackedRT BS 827+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013062417464Skin · crackedRT BS 787+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLES 1,2,4. REPAIRED SKIN IAW SB.SDR SWAA2013062417463Skin · crackedRT BS 867+10 LOWER FORWARD SKIN CUTOUT CRACKED AT HOLES 2,3,11. REPAIRED SKIN IAW SB.SDR SWAA2013062417462Skin · crackedRT BS 787+10 LOWER FORWARD SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013061917378Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 663.73 TO BS 685, STR 9R. R & R INTERCOSTAL IAW BAC DWG AND SRM.SDR SWAA2013061016933Slide · separatedL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY SEPARATED FROM HOUSING, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2013061016932Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2013061016931Cover · looseLEFT EMERGENCY LIGHT LENS COVER LOOSE AT ROW 21. SECURED COVER IAW AMM.SDR SWAA2013061016929Lens · looseLEFT EMERGENCY EXIT OVERHEAD DOOR SIGN LOOSE. R & R LENS IAW AMM.SDR SWAA2013061016912Controller · faultyAIR TURNBACK/DECLARED EMERGENCY CLIMBING THROUGH APPROXIMATELY FL 290 THE "CABIN ALTITUDE" LIGHT ILLUMINATED W/CABIN ALTITUDE WARNING HORN. R & R CABIN PRESSURE CONTROLLER IAW MM.SDR SWAA2013070817983Battery · dischargedFWD OTBD EMERGENCY FLASHLIGHT INOPERATIVE. R&R BATTERY IAW MM.SDR SWAA2013062517530Web · corrodedWEB CORRODED BETWEEN BS 992.8 TO BS 1006, STRINGER 17R. R&R WEB IAW SRM & DRAWING.SDR SWAA2013061717187Angle · crackedLT NACELLE ANGLE CRACKED AT STA 280.35 OTBD. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013061016999Support Angle · crackedLEFT MAIN WHEEL WELL SUPPORT ANGLE CRACKED AT BS 680. R & R ANGLE IAW DWG AND SRM.SDR SWAA2013060716889Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MM.SDR SWAA2013070217858Floorbeam · crackedTRANSVERSE FLOOR BEAM CRACKED AT BS 727B, LBL 24.82. REPAIRED BEAM IAW ER & EA.SDR SWAA2013070217857Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT BS 652, BBL 0.07. REPAIRED CHORD IAW ER & EA.SDR SWAA2013070117798Structure · corrodedAUX CHORD CORRODED AT BS 727. R&R CHORD PER SRM & DWG.SDR SWAA2013062517529Frame · crackedFRAME WEB CRACKED AT BS 847, BETWEEN STRINGER 11L - STRINGER 13L. REPAIRED FRAME IAW SRM.SDR SWAA2013062517528Frame · crackedFRAME WEB CRACKED AT BS 847, BETWEEN STRINGER 11L TO STRINGER 13L. REPAIRED FRAME IAW SRM.SDR SWAA2013062517521Web · crackedRT FLOOR WEB CRACKED BETWEEN BS 178 TO BS 188, WL 208. R&R WEB IAW SRM.SDR SWAA2013061917416Attach Angle · corrodedBULKHEAD LOWER ATTACH ANGLE CORRODED AT BS 947, STR 23R. R & R ANGLE IAW SRM.SDR SWAA2013061817316Stringer · corrodedSTRINGER CORRODED AT BS 992, STR 21R. R&R STRINGER IAW SRM.SDR SWAA2013060716910Wire Harness · faultyCAPT SLIDING WINDOW SPARKED AT THE CONNECTOR PLUG. R & R PIG TAIL IAW MM.SDR SWAA2013060516781Light · inoperativeLEFT EMERGENCY EXIT LIGHT INOP BETWEEN ROW 20 TO ROW 21. R & R LAMP IAW MM.SDR SWAA2013060516788Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE BRACKET CRACKED. R & R BRACKET IAW AMM.SDR SWAA2013060516787Strap · brokenTEFLON NUTPLATE ATTACH STRIP BROKEN ON AFT EDGE OF WHERE NR 1 PYLON PANEL 57710L ATTACHES. REPAIRED STRAP IAW EA.SDR SWAA2013060516783Battery Pack · dischargedR2 DOOR INTERIOR EMERGENCY LIGHT INOP. RECONNECTED BATTERY PACK IAW AMM.SDR SWAA2013060516782Battery Pack · dischargedL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RECONNECTED BATTERY PACK IAW AMM.SDR SWAA2013070217856Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD AFT END CRACKED AT BS 727A+18.5, LBL 26. R&R CHORD IAW EA.SDR SWAA2013062617624Web · crackedWEB CRACKED BETWEEN BS 188 - BS 196.5, STRINGER 17L. R&R WEB IAW SRM & DRAWING.SDR SWAA2013061817315Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD AFT END CRACKED AT BS 727A+17, RBL 47. REPAIRED CHORD IAW SWA EA.SDR SWAA2013061817314Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 986 TO BS 1006, STR 21R. REMOVED AND REPLACED INTERCOSTAL IAW SRM AND DWG.SDR SWAA2013060616841Lens · brokenFWD ENTRY EMERGENCY EXIT LEN BROKEN OFF. R & R LENS IAW MM.SDR SWAA2013060616839Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER. REINSTALLED SLIDE IAW MT.SDR SWAA2013070117786Channel · crackedCHANNEL CRACKED BETWEEN BS 188 & BS 203.8, RBL 6. R&R CHANNEL IAW SRM & DRAWING.SDR SWAA2013070117787Channel · crackedCHANNEL CRACKED BETWEEN BS 188 AND BS 203.8, LBL 6. R&R CHANNEL IAW SRM AND DWG.SDR SWAA2013062817741Skin · crackedSKIN CUTOUT CRACKED AT BS 973, STRINGER 23R. REPAIRED SKIN IAW SRM.SDR SWAA2013062817731Web · crackedWEB CRACKED BETWEEN BS 178 - BS 188, LBL 30. R&R WEB IAW SRM & DRAWING.SDR SWAA2013062617623Strap · crackedFWD ENTRY DOOR CUTOUT STRAP CRACKED BETWEEN BS 294.5 - BS 303.9, STRINGER 16L. R&R STRAP IAW SRM & DRAWING.
Back to Boeing 737-3H4