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 SWAA2014081930991Angle · crackedRIGHT WING PYLON ANGLE CRACKED ON INTERNAL CAVITY OF ACCESS PANEL 5858R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081930973Crease Beam · corrodedFORWARD LT CABIN CREASE BEAM WEB CORRODED BETWEEN BS 400 TO 420. REPAIRED WEB IAW SRM & DWG.SDR SWAA2014081430854Angle · corrodedAFT LT CABIN CREASE BEAM OUTER CHORD SPLICE ANGLE CORRODED AT BS 907. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731318Stop Fitting · crackedOUTER FRAME LOWER FASTENER ROW, INBD FASTENER HOLE FOR DOOR STOP FITTING CRACKED AT BS 348.2 STRINGER 16L. REPAIRED FITTING IAW EA.SDR SWAA2014082731287Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 483 TO 585 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014082731286Skin · crackedFUSELAGE SKIN CRACKED AT BS 442 STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014081430850Skin · crackedFUSELAGE SKIN CRACKED AT BS 374 STRINGER 19R. REPAIRED SKIN IAW SRM.SDR SWAA2014081330829Web · crackedWEB CRACKED BETWEEN BS 787 TO 807 RBL 12. R & R WEB IAW SRM & DWG.SDR SWAA2014082731285Skin · crackedFUSELAGE SKIN CRACKED AT BS 424 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014082731284Skin · crackedFUSELAGE SKIN CRACKED AT BS 434 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014082531186Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED. REPAIR AFT FLAP IAW SRM.SDR SWAA2014082531135Floor Support · corrodedFLOOR SUPPORT CORRODED AT BS 727D+6 LBL 8. R & R SUPPORT IAW SRM & DWG.SDR SWAA2014081930971Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727B STRINGER 8R. R & R CLIP IAW SRM & DWG.SDR SWAA2014081430849Skin · crackedFUSELAGE SKIN CRACKED AT BS 417 STRINGER 19L. REPAIRED SKIN IAW SRM.SDR SWAA2014082831382Frame · corrodedFRAME CORRODED AT BS 992.5 STRINGER 17R. REPAIRED FRAME IAW ER & EA.SDR SWAA2014082831381Repair · crackedFORWARD SERVICE DOOR FWD FRAME REPAIR ANGLE CRACKED AT BS 294 RBL. REPAIRED FRAME IAW ER & EA.SDR SWAA2014082731283Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 415 TO 418 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014082731282Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 453 TO 455 STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014082731281Skin · crackedFUSELAGE SKIN CRACKED AT BS 453 STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2014082731280Skin · crackedFUSELAGE SKIN CRACKED AT BS 443 STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014082731279Skin · crackedSKIN CRACKED AT BS 466 STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014082631254Skin · crackedSKIN CRACKED AT BS 787+12.3 STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2014082631253Skin · crackedSKIN CRACKED AT BS 787+12.25 STRINGER 24R. REPAIRED IAW EA.SDR SWAA2014082631247Skin · crackedSKIN CRACKED AT BS 787+10.5, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2014082531141Floorbeam · corrodedFLOORBEAM UPPER CHORD FLANGE CORRODED AT BS 967 RBL 5. REPAIRED FLANGE IAW SRM.SDR SWAA2014082531133Shear Web · corrodedSHEAR WEB CORRODED BETWEEN BS 1016 TO 1028 BETWEEN LBL 7 TO 34. R & R SHEAR WEB IAW SRM & DWG.SDR SWAA2014082531132Seat Track · corrodedSEAT TRACK CORRODED BETWEEN BS 994 TO 1008.5 RBL 37.5. R & R SEAT TRACK IAW SRM.SDR SWAA2014082531131Bracket · corrodedGIRT BAR BRACKET CORRODED AT BS 344, LBL 60. R & R BRACKET IAW SRM.SDR SWAA2014082531130Bracket · corrodedGIRT BAR BRACKET CORRODED AT BS 312, LBL 58. R & R BRACKET IAW SRM.SDR SWAA2014082531129Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 344, STRINGER 12R. R & R CLIP IAW SRM.SDR SWAA2014081930965Angle · crackedRIGHT WING ANGLE CRACKED AT REAR SPAR UPPER CHORD RSS 235. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081430848Skin · crackedFUSELAGE SKIN CRACKED AT BS 500D+11 STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2014081430847Doubler · crackedFUSELAGE SKIN DOUBLER CRACKED AT BS 513 STRINGER 19L. REPAIRED DOUBLER IAW SRM.SDR SWAA2014082531182Web · crackedLEFT WING FUEL TANK WEB CRACKED AT WBL 198.60 STRINGER 5 AT REAR SPAR. REPAIRED WEB IAW EO & EA.SDR SWAA2014082531181Plate · crackedUNDER WING TO BODY FAIRING PLATE CRACKED AT BS 540 LEFT SIDE. R & R PLATE IAW SRM & DWG.SDR SWAA2014090331572Support Channel · crackedRIGHT WW OTBD TOWER SHAFT SUPPORT CHANNEL OUTER CHORD CRACKED AT BS 348. REPAIRED CHORD IAW SRM.SDR SWAA2014082831380Structure · crackedAT BS 727 STRINGER 18A RT MAIN WW CHORD CRACKED, FWD LOWER & AFT LOWER HOLES. REPAIRED CHORD IAW ER & EA.SDR SWAA2014082831379Structure · crackedLEFT MAIN WW CHORD CRACKED AT BS 727 STRINGER 18A, FWD LOWER HOLE. REPAIRED CHORD IAW ER & EA.SDR SWAA2014082531180Web · crackedRIGHT WING UPPER WEB CHORD CRACKED AT WBL 198.60 STRINGER 5R. REPAIRED WEB IAW EO & EA.SDR SWAA2014082531128Floor Support · corrodedFLOORBEAM SUPPORT CORRODED BETWEEN BS 967 TO 986.5, RBL 17. R & R SUPPORT IAW SRM.SDR SWAA2014082531127Floor Panel · delaminatedCABIN FLOOR 2345X FWD END DELAMINATED. R & R PANEL IAW SRM & DWG.SDR SWAA2014081930990Flap · delaminatedLEFT WING TE OTBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014081930964Angle · crackedSPLICE ANGLE CRACKED ON CTR TANK AT LEVEL OF STRINGER 9C UPPER SURFACE WBL 70.85 RT SIDE. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081930963Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081930962Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5 STRINGER 23L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081330825Angle · crackedANGLE CRACKED AT BS 351.2, RACK E3 - 4. R & R ANGLE IAW SRM & DWG.SDR SWAA2014080830702Web · crackedWEB CRACKED BETWEEN BS 312 TO 328 LBL 45. R & R WEB IAW SRM & DWG.SDR SWAA2014080430556Actuator · leakingDIVERSION LT MLG EXTENDED WHEN FIRST OFFICER PUT LG HANDLE TO OFF. R & R LT MLG INBD ACTUATOR ASSEMBLY IAW AMM.SDR SWAA2014080430567Slide · unsecureR1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY & STILL OPERATIONAL. RE-INSTALLED SLIDE IAW MT.SDR SWAA2014082731290Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664 LBL 4. REPAIRED DECK IAW ER & EA.
Back to Boeing 737-3H4