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 SWAA2014061128941Release Cable · frayedR2 DOOR EMER EVAC SLIDE RELEASE CABLE FRAYED. R & R CABLE IAW AMM.SDR SWAA2014061028893Release Cable · frayedL2 DOOR EMER EVAC SLIDE RELEASE CABLE FRAYED. R & R CABLE IAW MM.SDR SWAA2014060928847Light · inoperativeRIGHT EMERGENCY EXIT BULLNOSE LIGHT INOPERATIVE AT ROW 9. R & R BULB IAW MM.SDR SWAA2014060928846Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE ASSEMBLY IAW MT.SDR SWAA2014060928818Light · inoperativeLEFT EMER EXIT BULLNOSE LIGHT INOPERATIVE AT ROW 14. R & R BULB IAW MM.SDR SWAA2014070729668Skin · crackedR2 DOOR SKIN CUT OUT CRACKED AT FWD LOWER CORNER FROM FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SWAA2014070229588Skin · crackedFUSELAGE SKIN CRACKED AT STATION 947.5+14, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014062729466Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 1006, STRINGER 10L. R & R CLIP IAW EA.SDR SWAA2014062529392Web · crackedCENTER WING BOX LONGITUDINAL BEAM WEB CRACKED AT BS 709, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014061228981Floorbeam · crackedFLOORBEAM CRACKED AT BS 328, LBL 35. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014061228980Floorbeam · crackedFLOORBEAM CRACKED AT BS 328, LBL 28. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014061128940Strap · crackedUPPER SURFACE STRAP CRACKED AT BS 312, LBL 45.6. R & R STRAP IAW SRM & DWG.SDR SWAA2014060928803Hydraulic Line · faultyA SYS HYD PRESS & QTY WENT TO 0 WHEN LANDING GEAR SELECTED DOWN. R & R NOSE GEAR ACTUATOR EXTEND HYD LINE IAW SIP.SDR SWAA2014070329620Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 650, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2014070229592Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT STATION 664+9, LBL 24.50+17. REPAIRED WEB IAW EA.SDR SWAA2014070229591Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT STATION 664+9, LBL 24.50+15. REPAIRED WEB IAW EA.SDR SWAA2014062629429Shear Tie · crackedFUSELAGE FRAME SHEAR TIE CRACKED AT STATION 360, STRINGER 14L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014062529393Stringer Clip · crackedMAIN CABIN STRINGER CLIP CRACKED AT BS 380, STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2014061929206Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664+2, RBL 24.50+17. REPAIRED WEB IAW SRM.SDR SWAA2014061929205Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664+2, RBL 24.50+14. REPAIRED WEB IAW SRM.SDR SWAA2014061629077Angle · crackedNUMBER 2 PYLON LOWER SUPPORT STRUCTURE OF ACCESS PANEL 5858R ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014060928856Plate · damagedR1 DOOR EMER EVAC SLIDE FLOOR BRACKETS ADAPTER PLATE DAMAGED. R & R PLATE IAW AMM.SDR SWAA2014060928870Window Frame · crackedWINDOW FRAMES 1L & 6L CRACKED. R & R FRAME IAW AMM.SDR SWAA2014070129564Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 671, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2014070129563Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 667, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2014070129546Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A RT. REPAIRED FRAME IAW EA.SDR SWAA2014070129545Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A LT. REPAIRED FRAME IAW EA.SDR SWAA2014062629411Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A RT SIDE. REPAIRED FRAME IAW EA.SDR SWAA2014062629410Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A LT SIDE. REPAIRED FRAME IAW EA.SDR SWAA2014062529391Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014062529390Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014062529387Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014062029254Light · looseRIGHT EMER EXIT LIGHT OF G4 QUICK DISCONNECT PLUG LOOSE. R & R LIGHT ASSEMBLY IAW SWPM.SDR SWAA2014060928812Gasper Fan · faultyAIR TURN BACK, CLIMBING THRU 700 MSL SMOKE & FUMES IN THE CABIN. LEVELED OFF AT 11,000 MSL. R & R GASPER FANS ASSEMBLY IAW MM.SDR SWAA2014060628791Battery · dischargedAFT GALLEY FLASHLIGHT CHARGE INDICATOR INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2014060628790Skin · crackedLEFT WING NR 2 SLAT CRACKED AT LOWER SURFACE AFT ROW OF FASTENERS AT ACTUATOR ATTACHMENT. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2014060528717Slide · low pressureR2 DOOR EMER EVAC SLIDE PRESS LOW. R & R SLIDE IAW MT.SDR SWAA2014060528705Flap · delaminatedRIGHT WING INBD LE FORE FLAP DELAMINATED. R & R FORE FLAP IAW MM.SDR SWAA2014061729117Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STRINGER 5R TO 6R. REPAIRED SKIN IAW EA.SDR SWAA2014060928814Skin · crackedSKIN CRACKED AT BS 440+2, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2014060528719Cover · misalignedAFT CABIN EMER EXIT SIGN COVER MISALIGNED. ALIGNED COVER IAW MM.SDR SWAA2014060528718Sign · looseL1 DOOR LOWER EXIT SIGN LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014070229596Stringer Splice · crackedSTRINGER SPLICE CRACKED AT STATION 360, STRINGER 4L. REPAIRED STRINGER IAW EA.SDR SWAA2014060528713Web · corrodedWEB CORRODED BETWEEN BS 380 TO BS 400, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2014060428669Stiffener · corrodedPRESSURE WEB BULKHEAD CHANNEL STIFFENERS CORRODED AT BS 1016, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED STIFFENER IAW EO & EA.SDR SWAA2014060328642Container · brokenR2 DOOR EMER EVAC SLIDE CONTAINER BROKEN. R & R SLIDE IAW MT.SDR SWAA2014060228571Light · inoperativeRIGHT OVERHEAD EMER EXIT CEILING LIGHTS INOPERATIVE BETWEEN ROWS 15 TO ROW 17. RELAMPED LIGHTS IAW AMM.SDR SWAA2014060428659Channel · crackedRIGHT NLG WW CHANNEL CRACKED. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014060228591Angle · crackedRIGHT WING UPPER INBD FIXED TE ANGLE CRACKED AT BS 727, WBL 72.25. R & R ANGLE IAW SRM & DWG.SDR SWAA2014060228609Door · crackedRIGHT WING FIXED LE AT KRUGER FLAP SEAL DOOR CRACKED. REPAIRED DOOR IAW EA.
Back to Boeing 737-3H4