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 SWAA2015032637896Door · crackedLEFT MLG MIDDLE DOOR & AFT ATTACH FITTING CRACKED. R & R DOOR IAW MM.SDR SWAA2015032637895Angle · crackedLEFT WING NR 4 CANOE FAIRING INBD ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015032637894Skin · delaminatedLEFT WING NR 4 CANOE FAIRING SKIN DELAMINATED ON FWD LE SIDE. REPAIRED SKIN IAW SRM.SDR SWAA2015032637889Bracket · crackedRIGHT WING AILERON COVE BRACKET CRACKED AT LOWER CORNER. R & R BRACKET IAW SRM.SDR SWAA2015032637888Arm · corrodedLEFT WING INBD FORE FLAP INBD CONNECTING ARMS CORRODED. R & R FORE FLAP IAW MM.SDR SWAA2015032637860Skin · crackedLEFT HORIZONTAL STABILIZER CRACKED LOWER SURFACE, AFT SPAR AT APPROX 55" OTBD OF FUSELAGE. REPAIRED STABILIZER IAW SRM.SDR SWAA2015032637859Skin · crackedL1 DOOR EXTERNAL SKIN CRACKED AT UPPER AFT CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2015032537778Lens · unsecureFORWARD GALLEY EXIT LIGHT COVER LENS FELL OFF. R & R LENS IAW EA.SDR SWAA2015052039857Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STRINGER 20L - 21L. REPAIRED FRAME IAW EA.SDR SWAA2015050639332Angle · crackedFORWARD AREA OF WING TO BODY FAIRING ANGLE CRACKED AT BS 540, STRINGER 24L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015050439236Angle · crackedSPLICE ANGLE CRACKED AT BS 540, BETWEEN STRINGER 21L - 22L. R & R ANGLE IAW EA.SDR SWAA2015040738248Drag Angle · crackedLEFT DRAG ANGLE INTERNAL FWD AREA OF WING TO BODY FAIRING BETWEEN BS 520 - 540 CRACKED. REPAIRED ANGLE IAW SRM.SDR SWAA2015040138036Tee Fitting · crackedLEFT KEEL BEAM INBD TEE SUPPORT CRACKED AT BS 727, LBL 7. R & R TEE FITTING IAW SRM & DWG.SDR SWAA2015033137997Support Angle · crackedRIGHT MAIN WW CUT OUT SUPPORT ANGLE CRACKED AT BS 663.75+17. R & R ANGLE IAW SRM & DWG.SDR SWAA2015033037949Sign · looseRIGHT EMER EXIT SIGN LOOSE AT ROW 11. SECURED SIGN ASSEMBLY IAW SIP.SDR SWAA2015032437747Battery · dischargedLEFT EMER LIGHTS INOPERATIVE BETWEEN ROWS 10 - 18. R & R BATTERY IAW AMM.SDR SWAA2015052940218Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 19L. REPAIRED FRAME IAW EA.SDR SWAA2015052139904Crease Beam · crackedLEFT CREASE BEAM INNER CHORD CRACKED AT BS 616, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2015051839777Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STRINGER 20R - 21R. REPAIRED FRAME IAW SRM.SDR SWAA2015033137996Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706+1.5, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2015033137995Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706+1.5, RBL 24.8.ON BS 706 + 4.75. REPAIRED WEB IAW EA.SDR SWAA2015060340316Frame · crackedFUSELAGE MAIN FRAME CRACKED AT LT STATION 727. REPAIRED FRAME IAW EA.SDR SWAA2015052640005Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT AT FWD LOWER FASTENER HOLE. REPAIRED FRAME IAW EA & EO.SDR SWAA2015052640006Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED AT RSS 222 MLG AFT SUPPORT FITTING COMMON AREA. REPAIRED CHORD IAW EO & EA.SDR SWAA2015052239933Structure · crackedFORWARD LOWER FASTENER HOLE OTBD CHORD CRACKED AT BS 727, STRINGER 18A RT. R & R CHORD IAW EA.SDR SWAA2015051439654Door · crackedGROUND AIR CONDITIONING ACCESS DOOR CRACKED AT LOWER OTBD FUSELAGE. R & R DOOR IAW DWG & SRM.SDR SWAA2015050439235Web · corrodedWEB CORRODED BETWEEN BS 887 - 907, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2015042839061Angle · crackedL1 DOOR AFT LOWER CORNER ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042438908Frame · crackedRIGHT FRAME OTBD CHORD CRACKED AT BS 727. REPAIRED CHORD IAW EA.SDR SWAA2015041338410Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 847, STRINGER 1. R & R BRACKET IAW SRM & DWG.SDR SWAA2015041338409Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 887, STRINGER 1. R & R BRACKET IAW SRM & DWG.SDR SWAA2015041338408Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 907, STRINGER 1. R & R BRACKET IAW SRM & DWG.SDR SWAA2015040738236Tie Clip · crackedTIE CLIP CRACKED AT BS 986.5, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015040638127Tie Clip · crackedTIE CLIP CRACKED AT BS 827, STRINGER 16R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015032637878Slide · unsecureL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2015050439234Frame · crackedRIGHT FRAME OTBD CHORD CRACKED AT BS 188. REPAIRED CHORD IAW SRM.SDR SWAA2015050139204Frame · crackedFRAME OTBD CHORD CRACKED AT BS 188 AT LEVEL FLOOR STRUCTURE LT SIDE CONTROL CABIN. REPAIRED CHORD IAW SRM.SDR SWAA2015042738977Web · crackedLEFT FLOOR STRUCTURE WEB CRACKED BETWEEN BS 188 - 196.5, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015042438906Web · crackedRIGHT WEB CRACKED BETWEEN BS 188 - 196.5. R & R WEB IAW SRM & DWG.SDR SWAA2015041338401Web · crackedWEB CRACKED BETWEEN BS 277 - 294.5, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015040638156Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015032637848Fitting · corrodedRIGHT WING MID SPAR FITTING CORRODED. R & R FITTING IAW SRM.SDR SWAA2015032337733Shutoff Valve · faultyDECLARED EMER, CABIN ALTITUDE WARNING HORN SOUNDED AT 370. CABIN ALTITUDE INDICATION 10,500' & CLIMBING AT 700' PER MIN. EMER DECLARED WITH EMER DESCENT. NO DEGRADED SYS INDICATIONS WERE INDICATED ON PRESS CONTROLLER. CABIN CONTINUED UP TO 13,800' DURING DSDR SWAA2015032337699Bracket · crackedRIGHT WING PANEL 5835R AFT SUPPORT INBD BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2015032337698Flap Track · looseRIGHT WING INBD FORE FLAP, OTBD TOGGLE, OTBD TRACK LOOSE. SECURED TRACK IAW CMM.SDR SWAA2015032337697Skin · crackedRIGHT WING NR 4 SLAT LE SKIN CRACKED AT THE LOWER AFT FASTENER ROW, 30 INCHES FROM THE INBD END. REPAIRED SKIN IAW SRM.SDR SWAA2015032337709Door · delaminatedLEFT MLG INNER DOOR DELAMINATED. R & R DOOR IAW AMM.SDR SWAA2015041538522Strap · crackedSTRAP CRACKED AT BS 328+2, RBL 50.5. R & R STRAP IAW SRM & DWG.SDR SWAA2015041538521Strap · crackedSTRAP CRACKED AT BS 328, LBL 11. R & R STRAP IAW SRM.SDR SWAA2015041538520Stanchion · crackedSTANCHION CRACKED AT BS 259.5+3, BETWEEN STRINGER 11R - 27R. R & R STANCHION IAW SRM & DWG.
Back to Boeing 737-3H4