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 SWAA2015030937211Skin · crackedSKIN CRACKED BETWEEN BS 500B+4.5 TO 500B+15, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2015030537140Skin · crackedSKIN CRACKED BETWEEN BS 500B+6 TO 500B+7, STRINGER 16L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015030437100Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 25. REPAIRED CHORD IAW EA.SDR SWAA2015030337060Door Frame · crackedAFT CARGO BAY DOOR, FWD LOWER CORNER FRAME CRACKED 1" BELOW LOWER STOP FITTING, AT INBD FASTENER HOLE. REPAIRED FRAME IAW RO.SDR SWAA2015030237009Attach Angle · crackedLEFT WING INBD NO STEP PANEL INBD ATTACH ANGLE CRACKED AT AFT END. R & R ANGLE IAW SRM & DWG.SDR SWAA2015022736965Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2015022736964Beam · crackedBEAM UPPER CHORD CRACKED AT BS 328, LBL 28. R & R CHORD IAW SRM.SDR SWAA2015022736963Support Angle · crackedLEFT WING RSS 548 WIPER WEB SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015022736962Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 669, LBL 25. REPAIRED CHORD IAW EA.SDR SWAA2015020536347Lens · brokenFORWARD ENTRY DOOR EMER EXIT SIGN BROKEN. R & R LENS IAW SIP.SDR SWAA2015040238084Skin · crackedLOWER CONDITIONED AIR DOOR 1304, RT SIDE OF DOOR CUT OUT CRACKED. REPAIRED CUT OUT IAW ER & EA.SDR SWAA2015032737918Sign · brokenG1 GALLEY EMER EXIT SIGN BROKEN. R & R SIGN IAW MM.SDR SWAA2015032337723Pressure Deck · crackedMAIN WW BEADED PRESS DECK CRACKED AT BS 665, RBL 39. REPAIRED DECK IAW ER & EA.SDR SWAA2015031137326Frame · crackedFRAME CRACKED AT BS 360, STRINGER 20R. REPAIRED FRAME IAW EA.SDR SWAA2015020436336Fuse · blownRIGHT EMER EXIT BULLNOSE LIGHT INOPERATIVE BETWEEN ROW 20 - 23. R & R FUSE IAW AMM.SDR SWAA2015041438487Support Fitting · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT MLG AFT SUPPORT FITTING. REPAIRED FITTING IAW EA.SDR SWAA2015030337059Fairing · crackedRIGHT WING AILERON TAB MAST FAIRING 8814 CRACKED. R & R FAIRING IAW PO.SDR SWAA2015020436335Fuse · blownR2 DOOR OVERHEAD EMER EXIT SIGN INOPERATIVE. R & R FUSE IAW AMM.SDR SWAA2015020436334Fuse · blownLEFT EMER AISLE LIGHT INOPERATIVE AT ROW 10. R & R FUSE IAW AMM.SDR SWAA2015020436333Fuse · blownRIGHT EMER AISLE LIGHT INOPERATIVE BETWEEN ROW 8 - 9. R & R FUSE IAW AMM.SDR SWAA2015020436332Fuse · blownL1 DOOR OVERHEAD EMER EXIT SIGN INOPERATIVE. R & R FUSE IAW MM.SDR SWAA2015020436331Slide · looseL1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2015020436319Slide · looseR1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW SIP.SDR SWAA2015020336285Light · inoperativeRIGHT OVERWING DOOR SIDEWALL SIGN LIGHT ASSEMBLY INOPERATIVE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015031637445Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 600, RBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2015031237351Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM LOWER CHORD FWD MOST FASTENER HOLE CRACKED AT BS 600, LBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2015020436303Cover · looseLEFT OVERWING DOOR EXIT ESCAPE STRAP COVER LOOSE. SECURED COVER IAW MM.SDR SWAA2015020336301Gasper Fan · faultyDIVERSION, DURING CRUISE FL370 SMELLED STRONG BURNING SMELL IN COCKPIT & CABIN. NO SMOKE NOTED. R & R GASPER FAN IAW MM.SDR SWAA2015020336286Spoiler · brokenLEFT WING INBD GND SPOILER ATTACH POINT TO OUTBOARD ACTUATOR BROKEN. R & R GND SPOILER IAW MM.SDR SWAA2015032337702Strap · corrodedAFT CARGO COMPARTMENT SURROUND DOUBLER STRAP CORRODED AT BS 787, BETWEEN STRINGER 25R - 26R. REPAIRED STRAP IAW EA.SDR SWAA2015032337701Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986, BETWEEN RBL 15 - 44. REPAIRED BEAM IAW SRM.SDR SWAA2015031337400Frame · crackedFUSELAGE FRAME CRACKED AT STATION 520, STRINGER 22L. REPAIRED FRAME IAW SRM.SDR SWAA2015030537139Angle · corrodedAFT CARGO COMPARTMENT FAIL SAFE STRAP LOWER SURFACE ANGLE CORRODED AT BS 807 FRAME AFT FACE 6:00 POSITION. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2015030236998Threshold · corrodedLOWER FLANGE OF ZEE L2 THRESHOLD CORRODED. R & R FLANGE IAW DWG.SDR SWAA2015030236997Threshold · corrodedTOP FLANGE OF ZEE L2 THRESHOLD CORRODED. R & R FLANGE IAW DWG.SDR SWAA2015022336803Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4R. R & R SPLICE IAW EA.SDR SWAA2015021736642Floorbeam · corrodedFLOORBEAM UPPER CHORD T SECTION CORRODED AT BS 967, RBL 27. REPAIRED T SECTION IAW SRM.SDR SWAA2015020236270Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 3L. R & R CLIP IAW DWG.SDR SWAA2015020236283Fuse · failedAIR TURN BACK, BOTH WING LE DEVICES, FLAPS & SLATS FAILED TO RETRACT AFTER TAKEOFF. TE FOLLOWED FLAP LEVER SETTING. RESET B SYS EXTEND FUSE IAW MM.SDR SWAA2015032737929Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 676 - 686, RBL 24. REPAIRED BEAM IAW EA.SDR SWAA2015031637439Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20L TO 2IL. REPAIRED FRAME IAW EA & DWG.SDR SWAA2015020936420Attach Angle · crackedLONGITUDINAL FLOORBEAM VERTICAL WEB ATTACH ANGLE CRACKED AT BS 727B, RBL 45. R & R ANGLE IAW DWG & SRM.SDR SWAA2015020236252Fitting · looseR1 DOOR EMER AFT FLOOR MOUNTED GIRT BAR FITTING LOOSE. SECURED FITTING IAW SRM.SDR SWAA2015020236251Light · inoperativeFORWARD SERVICE DOOR EMER LIGHT INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2015030937201Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 5L. R & R SPLICE IAW EA.SDR SWAA2015030237026Door Sill · corrodedLEFT AFT SILL INNER CHORD CORRODED BETWEEN BS 947 TO 1006, LBL 58. R & R CHORD IAW SRM & DWG.SDR SWAA2015030236996Support · corrodedL2 DOOR CUT OUT THRESHOLD SUPPORT CORRODED ON UPPER SURFACE. REPAIRED CUT OUT IAW SRM & DWG.SDR SWAA2015022336802Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4L. R & R IAW EA.SDR SWAA2015022336801Structure · corrodedR1 CHORD CORRODED BETWEEN BS 291 - 332. R & R CHORD IAW SRM.SDR SWAA2015022036755Angle · corrodedR1 DOOR LOWER SILL NUTPLATE ANGLE CORRODED. R & R ANGLE IAW SRM & DWG.
Back to Boeing 737-3H4