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 SWAA2016033150456Floor Support · crackedLONGITUDINAL FLOORBEAM INBD & OTBD FLANGE CRACKED AT BS 727B, RBL 24.8. REPAIRED FLANGE IAW ER & EA.SDR SWAA2016030749726Skin · crackedLEFT WING UPPER SKIN CRACKED, AT WBL 189. REPAIRED SKIN IAW EA.SDR SWAA2016030749687Fairing · crackedRIGHT WING LOWER FIXED TE PANEL, OTBD OF NR 6 FLAP TRACK FAIRING CRACKED. R & R FAIRING IAW SRM.SDR SWAA2016030449648Flap · delaminatedRIGHT WING INBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2016030449628Slide · out of positionL1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.SDR SWAA2016030349626Hydraulic Line · faultyDECLARED EMER, LOSS OF A SYS HYD QTY. R & R LT MLG RETRACT LINE IAW AMM.SDR SWAA2016030349625Gasper Fan · faultyDURING DESCENT SLIGHT ODOR NOTICED IN COCKPIT. SMELLED LIKE BURNT RUBBER OR WIRE. TURNED OFF RECIRC, BUT SMELL NEVER WENT AWAY. R & R GASPER FAN IAW MM.SDR SWAA2016040750691Skin · crackedRIGHT WING INSPAR UPPER SKIN TE CRACKED AT REAR SPAR RSS 290. REPAIRED SKIN IAW EA.SDR SWAA2016032850273Rib · crackedRIGHT WING RIB CRACKED EXISTING FILLER INTERNAL AREA ON WBL 114.00, STRINGER 2R UPPER CHORD REAR SPAR. REPAIRED RIB IAW EA.SDR SWAA2016030749716Shear Tie · corrodedSHEAR TIE CORRODED AT BS 400, BETWEEN STRINGER 24L - 25L. REPAIRED SHEAR TIE IAW EA.SDR SWAA2016030349608Skin · delaminatedRIGHT WING NR 8 SPOILER TOP SURFACE DELAMINATED. R & R NR 8 SPOILER IAW MM.SDR SWAA2016032150046Skin · crackedL1 DOOR UPPER & LOWER HINGE CUT OUT DOUBLER CRACKED AT BS 305, STRINGER 10L. REPAIRED CUT OUT IAW EA.SDR SWAA2016031449852Shear Tie · corrodedSHEAR TIE ANGLE CORRODED, AT BS 500D, RBL 8. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016031049785Shear Tie · corrodedFORWARD CARGO PIT UNDER FLOOR, SHEAR TIE ANGLE CORRODED, AT BS 500D, BETWEEN LBL 6 TO RBL 6. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016030949773Attach Fitting · corrodedVERTICAL KEEL BEAM ATTACH CLIP CORRODED, AT BS 500D, LBL 6. R & R CLIP IAW SRM & DWG.SDR SWAA2016030749705Skin · crackedLEFT WING INBD FORE FLAP CRACKED ON LOWER SURFACE TE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2016030749686Fitting · crackedFORWARD CARGO PIT LT CLIP CRACKED AT BS 540. R & R CLIP IAW DWG & SRM.SDR SWAA2016030249595Slide · out of adjustR1 DOOR SLIDE GIRT BAR RETAINER OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW SIP.SDR SWAA2016032350167Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 360, STRINGER 2L. R & R CLIP IAW SRM.SDR SWAA2016032350166Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 360, STRINGER 1. R & R CLIP IAW SRM.SDR SWAA2016032250120Tie Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 360, STRINGER 5L. R & R CLIP IAW SRM & DWG.SDR SWAA2016022949489Lens · brokenFORWARD ENTRY EMER EXIT LIGHT LENS BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016041450914Bear Strap · crackedAFT ENTRY DOOR LOWER FWD CORNER CRACKED IN BEAR STRAP. REPAIRED BEAR STRAP IAW EA.SDR SWAA2016022949516Lens · looseFORWARD EXIT DOOR, EXIT SIGN LENS COVER LOOSE. R & R LENS IAW MM.SDR SWAA2016022949506Light · inoperativeFORWARD ENTRY DOOR AFT EMER EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016022949494Support Angle · crackedLEFT WING TE SUPPORT ANGLE CRACKED ON WBL 198.60. R & R ANGLE IAW SRM & DWG.SDR SWAA2016022649493Support Angle · crackedRIGHT WING TE SUPPORT ANGLE CRACKED ON WBL 198.60. R & R ANGLE IAW SRM & DWG.SDR SWAA2016041150767Crease Beam · crackedRIGHT CREASE BEAM CHORD CRACKED AT BS 639. REPAIRED CHORD IAW EA.SDR SWAA2016040750693Skin · crackedLEFT WING INSPAR UPPER SKIN TE CRACKED AT UPPER AT RSS 238.5. REPAIRED SKIN IAW EA.SDR SWAA2016040750690Skin · crackedLEFT WING INSPAR UPPER SKIN TE CRACKED AT RSS 152. REPAIRED SKIN IAW EA.SDR SWAA2016040750689Skin · crackedLEFT WING INSPAR UPPER SKIN TE CRACKED AT FASTENER HOLE UPPER REAR SPAR RSS 266. REPAIRED SKIN IAW EA.SDR SWAA2016040750688Skin · crackedLEFT WING INSPAR UPPER SKIN TE CRACKED AT UPPER REAR SPAR RSS 267. REPAIRED SKIN IAW EA.SDR SWAA2016040750687Skin · crackedLEFT WING INSPAR UPPER SKIN TE CRACKED AT UPPER REAR SPAR RSS 253. REPAIRED SKIN IAW EA.SDR SWAA2016040750686Skin · crackedLEFT WING INSPAR UPPER SKIN TE CRACKED AT UPPER REAR SPAR RSS 249. REPAIRED SKIN IAW EA.SDR SWAA2016040750685Skin · crackedLEFT WING INSPAR UPPER SKIN TE CRACKED AT UPPER REAR SPAR RSS 248.5. REPAIRED SKIN IAW EA.SDR SWAA2016040750675Crease Beam · crackedLEFT CREASE BEAM CHORD CRACKED JUST FWD OF BS 639. REPAIRED CHORD IAW EA.SDR SWAA2016040550602Hinge · crackedR1 DOOR LOWER HINGE STRUCTURE CRACKED. R & R HINGE IAW SRM & DWG.SDR SWAA2016040450598Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 269. REPAIRED SKIN IAW EA.SDR SWAA2016040450597Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 263. REPAIRED SKIN IAW EA.SDR SWAA2016040450596Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 261. REPAIRED SKIN IAW EA.SDR SWAA2016040450595Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 250.25. REPAIRED SKIN IAW EA.SDR SWAA2016040450594Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 254. REPAIRED SKIN IAW EA.SDR SWAA2016040450593Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 256. REPAIRED SKIN IAW EA.SDR SWAA2016040450601Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 168. REPAIRED SKIN IAW EA.SDR SWAA2016040450600Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 164. REPAIRED SKIN IAW EA.SDR SWAA2016040450599Skin · crackedRIGHT WING REAR SPAR UPPER SKIN CRACKED AT RSS 229.75. REPAIRED SKIN IAW EA.SDR SWAA2016040450555Frame · crackedFRAME WEB CRACKED AT BS 360, STRINGER 20R. REPAIRED FRAME WEB IAW EA.SDR SWAA2016031649955Skin · crackedFUSELAGE SKIN CRACKED AT STATION 520, GND SERVICE CONNECT CUT OUT. REPAIRED SKIN IAW SRM.SDR SWAA2016022949490Lens · missingFORWARD ENTRY DOOR, LOWER EXIT SIGN LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2016022949481Gasper Fan · faultyACRID SMELL IN COCKPIT. SMELL STARTED WITH GASPER FAN ON. SMELL DISSIPATED WHEN GASPER FAN TURNED OFF. R & R GASPER FAN IAW MM.
Back to Boeing 737-3H4