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 SWAA2014082531179Web · crackedSUPPORT WEB CRACKED BETWEEN BS 787 TO 807 RBL 20. R & R WEB IAW SRM & DWG.SDR SWAA2014082531126Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 340.5 TO 341.5, STRINGER 1R. REPAIRED SKIN IAW SRM.SDR SWAA2014081930961Fitting · crackedCLIP CRACKED AT BS 360 STRINGER 8L. R & R CLIP IAW SRM & DWG.SDR SWAA2014080430568Charger · inoperativeAFT EMER EXIT LIGHTS INOPERATIVE. R & R BATTERY CHARGER IAW AMM.SDR SWAA2014082731309Fitting · corrodedFORWARD LT BORE AT FITTING VERTICAL STABILIZER CORRODED. REPAIRED STABILIZER IAW EA.SDR SWAA2014082631246Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5 STRINGER 25R. REPAIRED TIE CLIP IAW EO & EA.SDR SWAA2014082531178Frame · crackedFRAME OUTER CHORD CRACKED AT BS 348.2 BETWEEN STRINGER 16L TO 17L. REPAIRED CHORD IAW EO & EA.SDR SWAA2014082531125Frame · crackedFUSELAGE FRAME CRACKED AT BS 520, BETWEEN STRINGER 20L TO 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014081930960Angle · crackedANGLE CRACKED BETWEEN BS 380 TO 400 BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081130739Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 500C STRINGER 26L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014080430555Lens · looseLEFT OVERWING EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM & SIP.SDR SWAA2014080430587Skin · delaminatedRIGHT WING OTBD AFT FLAP DELAMINATED ON INBD LOWER SURFACE. R & R AFT FLAP IAW AMM.SDR SWAA2014080130551Valve · leakingDECLARED EMER, A SYS HYD FAILURE. R & R VLV IAW MM.SDR SWAA2014080130528Housing · defectiveRIGHT AFT EMER EXIT BULLNOSE LIGHT INOPERATIVE. R & R BATTERY PACK HOUSING IAW AMM.SDR SWAA2014082831378Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5 BETWEEN RBL 25 TO 45. REPAIRED BEAM ASSEMBLY IAW ER & EA.SDR SWAA2014082631245Skin · crackedSKIN CRACKED AT BS 787+11.25, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2014082531200Skin · crackedSKIN CRACKED AT BS 360 STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014082531134Support Angle · corrodedFLOOR SUPPORT ANGLE CORRODED BETWEEN BS 967 TO 986.5 RBL 45. R & R ANGLE IAW SRM.SDR SWAA2014082031049Support Fitting · corrodedLEFT WING NR 4 FLAP TRACK AFT SUPPORT FITTING CORRODED. REPAIRED FITTING IAW CMM.SDR SWAA2014081330824Angle · crackedANGLE CRACKED BETWEEN BS 500D TO 520 BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081130730Bracket · crackedFORWARD CARGO COMPARTMENT BRACKET CRACKED AT BS 500D STRINGER 19R. R & R BRACKET IAW SRM & DWG.SDR SWAA2014080130536Skin · wornLEFT WING OTBD MID FLAP LEADING WORN. R & R MID FLAP IAW MM.SDR SWAA2014080130529Lens · brokenRIGHT OVERWING EMER EXIT LIGHT COVER BROKEN. R & R LENS ASSEMBLY IAW SIP.SDR SWAA2014080130523Tie Clip · crackedTIE CLIP CRACKED AT BS 460 STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531161Skin · delaminatedTAIL CONE UPPER SKIN DELAMINATED AT BS 1156+20. REPAIRED SKIN IAW SRM.SDR SWAA2014081430853Frame · crackedFUSELAGE FRAME CRACKED AT BS 500B+5.5 INCHES, STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014081430852Frame · crackedFUSELAGE FRAME CRACKED AT BS 520+5.5 INCHES STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014080630642Angle · corrodedAFT CARGO FLOOR SUPPORT CHANNEL CORRODED AT BS 727C+6.5 RBL 3.0. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080130531Skin · corrodedEXTERIOR FUSELAGE SKIN CORRODED UNDER AFT LAVATORY PAN. REPAIRED SKIN IAW SRM.SDR SWAA2014082531160Slat · brokenRIGHT WING NR 5 SLAT UPPER CORNER BROKEN. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2014082531159Frame · crackedFRAME OTBD CHORD FWD FLANGE CHORD CRACKED AT BS 727 STRINGER 18A RT. R & R CHORD IAW EA.SDR SWAA2014082531158Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18A LT. R & R CHORD IAW EA.SDR SWAA2014081931016Skin · crackedLEFT WING FIXED LE SKIN CRACKED AT WS 213. REPAIRED SKIN IAW EA.SDR SWAA2014081530912Structure · crackedRIGHT NLG WW CRACKED AT BS 243.7+3.5 WL 169.1. REPAIRED WW IAW SRM.SDR SWAA2014081330823Web · crackedNOSE LANDING GEAR WW WEB CRACKED AT BS 243.7+2.5 WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014081330822Structure · crackedUPPER CHORD CRACKED AT BS 669 LBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2014081230791Frame · crackedLEFT BS 500B+10 FRAME FOUND TO BE CRACKED AT HOLE NR 7R. R & R FORGING IAW DWG.SDR SWAA2014081130729Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016 STRINGER 13L. REPAIRED WEB IAW SRM.SDR SWAA2014081130728Shear Beam · crackedSHEAR BEAM WEB CRACKED CRACKED AT BS 727 STRINGER 18A RT SIDE. R & R WEB IAW SRM & DWG.SDR SWAA2014081130727Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664+9.5 LBL 24.5+6.5. REPAIRED DECK IAW SRM.SDR SWAA2014081130726Skin · crackedSKIN CRACKED AT BS 727 STRINGER 18A RT SIDE. REPAIRED SKIN IAW SRM.SDR SWAA2014080430586Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 RBL 13. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430585Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 RBL 8.0. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430584Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 RBL 3.0. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430583Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 LBL 8.0. REPAIRED ANGLE IAW SRM & EA.SDR SWAA2014080430582Angle · corrodedAFT PIT FLOOR SUPPORT CHANNEL ANGLE CORRODED AT BS 772 LBL 3. REPAIRED ANGLE IAW EA & SRM.SDR SWAA2014081330828Skin · crackedLEFT WING EXTERNAL SKIN ON FIXED LE UPPER SURFACE CRACKED AT LEVEL WBL 166.00. REPAIRED SKIN IAW SRM.SDR SWAA2014073130497Lug · crackedRIGHT WING TE GND SPOILER FITTING LUG CRACKED. REPAIRED LUG IAW EA.SDR SWAA2014072930448Flashlight · inoperativeFORWARD CABIN EMER FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM.SDR SWAA2014072830373Slide · unsecureL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY & STILL OPERATIONAL. REINSTALLED SLIDE IAW MM.
Back to Boeing 737-3H4