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 SWAA2014091632040Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727 STRINGER 18A LT SIDE, AFT LOWER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014091632039Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18A LT SIDE, FWD LOWER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014091632038Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727 STRINGER 18A RT SIDE, IN AFT LOWEST HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014091031790Angle · crackedLEFT MLG FWD CUT OUT OF INTERNAL AREA ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014090931753Pan · crackedLEFT AFT ENG MOUNT HEAT SHIELD PAN ASSEMBLY CRACKED FWD OTBD CORNER. REPAIR PAN ASSEMBLY IAW EA.SDR SWAA2014082731289Skin · delaminatedLEFT WING NR 2 SLAT UPPER SURFACE TE AT INBD AUXILIARY TRACK DELAMINATED. R & R NR 2 SLAT IAW MM.SDR SWAA2014082631228Fitting · crackedCLIP CRACKED AT BS 348.2 STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014082631214Skin · delaminatedLEFT WING NR 3 SLAT UPPER SURFACE TE INBD CORNER DELAMINATED. R & R NR 3 SLAT IAW MM.SDR SWAA2014082531103Battery Pack · dischargedRIGHT CABIN OVERHEAD BIN BULLNOSE EMER EXIT LIGHT INOPERATIVE AT ROW 8. R & R BATTERY PACK IAW MM.SDR SWAA2014082531124Skin · delaminatedLEFT WING NR 1 SLAT UPPER SURFACE TE CORNER DELAMINATED. R & R NR 1 SLAT IAW MM.SDR SWAA2014082531123Lens · looseRIGHT EMER EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2014082531111Skin · delaminatedLEFT WING NR 3 SLAT UPPER SURFACE TE INBD CORNER DELAMINATED. R & R NR 3 SLAT IAW MM.SDR SWAA2014082531110Battery Pack · dischargedLEFT CABIN OVERHEAD BIN BULLNOSE EMER EXIT LIGHTS INOPERATIVE BETWEEN ROW 6 TO 10. R & R BATTERY PACK IAW MM.SDR SWAA2014090931743Skin · crackedRIGHT WING FIXED LE SKIN CRACKED AT LEVEL WBL 157. REPAIRED SKIN IAW EA.SDR SWAA2014090331562Skin · crackedLEFT WING NR 2 SLAT SKIN LOWER SURFACE CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014090331558Frame · crackedFRAME CRACKED AT BS 787 BETWEEN STRINGER 26R TO 25R. REPAIRED FRAME IAW SRM.SDR SWAA2014090231529Spoiler · delaminatedLEFT WING NR 1 SPOILER DELAMINATED. REPAIRED NR 1 SPOILER IAW SRM.SDR SWAA2014090231484Skin · crackedFUSELAGE SKIN CRACKED AT BS 460+4 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014090231483Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+17 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014090231482Skin · crackedFUSELAGE SKIN CRACKED AT BS 500A+7 STRINGER 16L. REPAIRED SKIN IAW SRM.SDR SWAA2014082931421Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727C STRINGER 1L. R & R CLIP IAW SRM.SDR SWAA2014082531183Floorbeam · crackedCENTER WING BOX FLOORBEAM LOWER CHORD CRACKED AT BS 664 RBL 45.5. REPAIRED CHORD IAW EO & EA.SDR SWAA2014082531177Web · crackedMAIN WW DECK WEB CRACKED BETWEEN BS 664 TO 675, BETWEEN RBL 30 TO 50. REPAIRED WEB IAW EO & EA.SDR SWAA2014082131086Strap · crackedFLOOR STRUCTURE STABILIZER STRAP CRACKED AT BS 328, RBL 50.5. REPAIRED STRAP IAW SRM.SDR SWAA2014082031038Skin · crackedL1 DOOR INNER SKIN CRACKED AT LOWER HINGE BOX. REPAIRED SKIN IAW EA 1-352-1548.SDR SWAA2014090231552Door Frame · crackedL1 DOOR OPENING BS 348 LT FRAME OUTER CHORD CRACKED AT BS 348.2 STRINGER 16L. R & R CHORD IAW EA.SDR SWAA2014090231481Skin · crackedFUSELAGE SKIN CRACKED AT BS 967+11 STRINGER 21L. REPAIRED SKIN IAW SRM.SDR SWAA2014082031037Battery Pack · dischargedRIGHT AFT EMER LIGHT INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014082831392Angle · crackedAFT PRESS BULKHEAD STIFFENER ANGLE CRACKED AT BS 1016 STRINGER 3L. REPAIRED ANGLE IAW EA.SDR SWAA2014081930979Battery · dischargedAFT GALLEY EMER LIGHTS INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2014090231539Strap · crackedSTRAP CRACKED BETWEEN BS 348.2 TO 351.2 STRINGER 16L. R & R STRAP IAW SRM & DWG.SDR SWAA2014090231538Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907 STRINGER 3L. R & R SPLICE IAW SRM & DWG.SDR SWAA2014081930998Battery Pack · dischargedFORWARD LT STOW BIN EMER EXIT LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014081930947Battery Pack · dischargedL1 DOOR EMER EXIT LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014110533812Spring · brokenAFT CARGO DOOR HANDLE SPRING BROKEN. R & R SPRING IAW MM.SDR SWAA2014090931741Fitting · crackedCLIP CRACKED AT BS 294.5 STRINGER 23L. R & R CLIP IAW SRM & DWG.SDR SWAA2014090331561Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540 STRINGER 22L. REPAIRED ANGLE IAW SRM.SDR SWAA2014090331560Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 336 BETWEEN STRINGER 20L TO 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014090231548Shear Web · crackedAT L1 DOOR OPENING SHEAR WEB CRACKED AT BS 348 BETWEEN STRINGER 15L TO 17L AFT LOWER CORNER. R & R SHEAR WEB IAW SRM & EA.SDR SWAA2014090231537Stop Fitting · crackedL1 DOOR OPENING LT FRAME INNER CHORD STOP FITTING LOWER FWD CRACKED AT BS 348 STRINGER 16L. R & R FITTING IAW EA.SDR SWAA2014090231536Door Frame · crackedL1 DOOR OPENING LT FRAME OUTER CHORD STOP FITTING LOWER FWD CRACKED AT BS 348 STRINGER 16L. R & R FITTING IAW EA.SDR SWAA2014090231535Door Frame · crackedL1 DOOR OPENING LT FRAME INNER CHORD LOWER INBD HOLE CRACKED AT BS 348 WL 208. R & R CHORD IAW EA.SDR SWAA2014090231528Support Angle · corrodedSUPPORT ANGLE CORRODED AT BS 328 BETWEEN STRINGER 20L TO 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014090231527Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 320 BETWEEN STRINGER 20L TO 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014090231447Frame · crackedFRAME CRACKED AT BS 360 BETWEEN STRINGER 28L TO 28R. REPAIRED FRAME IAW EA.SDR SWAA2014082631227Channel · crackedCHANNEL CRACKED BETWEEN BS 312 TO 328 RBL 31.6. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014082631226Channel · crackedCHANNEL CRACKED BETWEEN BS 328 TO 344 LBL 45.5. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014082631225Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 27L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082631224Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 26L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531169Tie Clip · crackedTIE CLIP CRACKED AT BS 360 STRINGER 10L. R & R TIE CLIP IAW SRM & DWG.
Back to Boeing 737-3H4