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 SWAA2016020548735Fitting · crackedAFT CARGO COMPARTMENT CLIP CRACKED AT BS 927, STR 25R. R&R CLIP IAW SRM & DWG.SDR SWAA2016020548719Support Fitting · crackedLT WING AFT SUPPORT FITTING CRACKED AT NR 5 HOLE. R&R FITTING PER EA.SDR SWAA2016020548718Support Fitting · crackedRT WING AFT SUPPORT FITTING CRACKED AT NR 5 HOLE. R&R FITTING PER EA.SDR SWAA2016020448689Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STR 25L. R&R TIE CLIP IAW SRM AND DWG.SDR SWAA2016020248604Skin · delaminatedRIGHT WING INBD AFT FLAP DELAMINATED ON LOWER SURFACE. REPAIRED AFT FLAP IAW SRM.SDR SWAA2016020248603Skin · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED AT UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2016012648386Reveal · crackedL1 DOOR CUT OUT REVEAL CRACKED AT BS 329, STRINGER 6L. R & R REVEAL IAW DWG & SRM.SDR SWAA2016030849742Spar · crackedRIGHT WING REAR SPAR WEB CRACKED, AT STATION RSS 224.14, AT FASTENER HOLE. REPAIRED WEB IAW EA.SDR SWAA2016022949492Crossbeam · crackedAFT CARGO COMPARTMENT CROSSBEAM D, T CHORD CRACKED AT FWD END. REPAIRED T CHORD IAW EA.SDR SWAA2016022349293Intercostal · crackedFORWARD GALLEY DOORWAY INTERCOSTAL WEB CRACKED, BETWEEN BS 277 - 291.5, STRINGER 14R. REPAIRED WEB IAW EA.SDR SWAA2016021849193Frame · corrodedFRAME CORRODED AT BS 727B, BETWEEN STRINGER 25L - 26L. REPAIRED FRAME IAW SRM.SDR SWAA2016021148973Support Angle · crackedAFT CARGO COMPARTMENT, SUPPORT ANGLE CRACKED, AT BS 947.5, STRINGER 25L. R & R ANGLE IAW SRM & DWG.SDR SWAA2016021048908Skin · delaminatedLEFT WING INBD FORE FLAP DELAMINATED AT UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2016021048907Rib · crackedLEFT WING AT OTBD AILERON INBD RIB CRACKED. R & R RIB IAW SRM & DWG.SDR SWAA2016020548734Skin · delaminatedRT WING OUTBOARD FORE FLAP DELAMINATED AT UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2016022549368Skin · delaminatedLEFT WING AILERON LE, UPPER SKIN DELAMINATED. REPAIRED AILERON IAW EA & SRM.SDR SWAA2016022549367Splice · crackedRIGHT WING REAR SPAR, UPPER CHORD SPLICE ON FASTENER HOLE RSS. 222.5 CRACKED. REPAIRED SPLICE IAW EA.SDR SWAA2016021649152Splice · crackedRIGHT WING REAR SPAR WEB SPLICE CRACKED, BETWEEN RSS 211 - 238. REPAIRED SPLICE IAW EA.SDR SWAA2016021649142Rib · crackedRIGHT WING LOWER RIB CHORD CRACKED ON WBL 135.50, BETWEEN STRINGER 2 - 3. REPAIRED LOWER RIB CHORD IAW EA.SDR SWAA2016021649141Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED, BETWEEN RSS 220.5 - 285. REPAIRED CHORD IAW EA.SDR SWAA2016020948824Structure · crackedFORWARD GALLEY DOORWAY T CHORD CRACKED AT BS 332, STRINGER 8R. REPAIRED T CHORD IAW EA.SDR SWAA2016020948823Support · crackedAFT CARGO COMPARTMENT ANGLE SUPPORT CRACKED AT BS 727B, STRINGER 25L. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016020948822Support · crackedAFT CARGO COMPARTMENT ANGLE SUPPORT CRACKED AT BS 727, STRINGER 25L. R & R SUPPORT IAW SRM & DWG.SDR SWAA2016020548733Fitting · crackedCLIP CRACKED AT BS 328, BETWEEN STR 20L TO STR 21L. R&R CLIP IAW SRM AND DWG.SDR SWAA2016020448688Bulkhead · crackedAFT PRESSURE BULKHEAD DOME CAP WEB CRACKED AT BS 1016, RBL 4.5. REPAIRED WEB IAW SRM.SDR SWAA2016020148547Flap Track · corrodedLEFT WING NR 4 FLAP TRACK, UPPER SURFACE HOLE CORRODED. REPAIRED NR 4 FLAP TRACK IAW CMM.SDR SWAA2016011548023Wire · brokenON TAKEOFF WITH LG LEVER UP, THE LT MAIN GEAR RED LIGHT STAYED ILLUMINATED. RECYCLED LG, ALL LIGHTS WENT OUT. REPAIRED WIRE IAW SWPM.SDR SWAA2016011548015Sign · unsecureFORWARD DOOR EXIT SIGN FELL OFF. SECURED SIGN IAW AMM.SDR SWAA2016011347933Valve · failedAIR TURN BACK, DECLARED EMER CLIMBING THROUGH 25,000 FT. CABIN ALTITUDE WARNING HORN & FLIGHT ILLUMINATED. R & R NR 2 ENG HIGH STAGE VLV IAW AMM.SDR SWAA2016011347932Valve · failedAIR TURN BACK, DECLARED EMER CLIMBING THROUGH 25,000 FT. CABIN ALTITUDE WARNING HORN & FLIGHT ILLUMINATED. R & R NR 1 ENG HIGH STAGE VLV IAW AMM.SDR SWAA2016021649117Rib · crackedLEFT WING INSPAR RIB WEB CRACKED AT WBL 198.60, INTERNAL SURFACE REAR SPAR. REPAIRED RIB WEB IAW EA.SDR SWAA2016021649116Link · corrodedLEFT MLG SWING LINK PLATE CORRODED. REPAIRED LINK IAW CMM.SDR SWAA2016021649115Link · corrodedRIGHT MLG SWING LINK PLATE CORRODED. REPAIRED LINK IAW CMM.SDR SWAA2016021048906Bracket · crackedAFT CARGO COMPARTMENT, FWD BULKHEAD BRACKET ASSEMBLY CRACKED AT BS 727, RBL 3.0. R & R BRACKET ASSEMBLY IAW SRM & DWG.SDR SWAA2016013048465Rib · crackedRIGHT HORIZONTAL STABILIZER CRACKED ON LE RIB, LOCATED ON LE STATION 151.75. R & R RIB IAW SRM & DWG.SDR SWAA2016013048464Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2016012148257Skin · crackedLEFT MLG AFT EDGE INNER SKIN ON OUTER DOOR CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2016022349312Support Angle · crackedWING TO BODY STRUCTURE AT LOWER FUSELAGE SUPPORT ANGLE, CRACKED AT BS 520, STRINGER 22R. R & R ANGLE IAW SRM.SDR SWAA2016022349292Intercostal · crackedFORWARD GALLEY DOOR INTERCOSTAL WEB CRACKED, BETWEEN BS 277 - 291.5, STRINGER 14R. REPAIRED WEB IAW EA.SDR SWAA2016022349319Support Angle · crackedWING TO BODY STRUCTURE AT LOWER FUSELAGE SUPPORT ANGLE, CRACKED AT BS 520, STRINGER 22L. R & R ANGLE IAW SRM & DWG.SDR SWAA2016011948110Crease Beam · crackedCREASE BEAM WEB CRACKED AT BS 360, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2016011548036Lens · looseLEFT OVERWING EXIT LENS LOOSE. R & R LENS IAW MM.SDR SWAA2016011548035Light · inoperativeLEFT OVERWING EXIT DOOR LIGHT INOPERATIVE AT TOP. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2016011247911Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016021148972Light · brokenAFT CABIN PHOTO LUMINESCENT FLOOR PROXIMITY LIGHTING STRIP BROKEN. R & R STRIP IAW AMM.SDR SWAA2016012648392Stiffener · crackedWATER SERVICE PAN STIFFENER CRACKED AT BS 956, STRINGER 25L. R & R STIFFENER IAW SRM.SDR SWAA2016011347934Controller · failedDECLARED EMER, AUTO PRESSURIZATION MODE FAILED AFTER TAKEOFF. STANDBY MODE BECAME ACTIVE BUT CONTINUED TO OVER PRESSURIZE ACFT CABIN AT 2000 - 3000 FPM. R & R CABIN PRESS CONTROLLER IAW MM.SDR SWAA2016021849192Skin · crackedFORWARD ENTRY DOOR SKIN CUT OUT CRACKED AT BS 342 ON EXTERNAL AFT UPPER CORNER. REPAIRED CUT OUT IAW SRM.SDR SWAA2016020948810Seat Track · crackedSEAT TRACK OTBD FLANGE CRACKED AT BS 727B, RBL 24.8. REPAIRED SEAT TRACK IAW EA.SDR SWAA2016020948835Structure · crackedR1 DOOR CUT OUT T CHORD CRACKED AT BS 332, STRINGER 8R. REPAIRED T CHORD IAW EA.
Back to Boeing 737-3H4