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 SWAA2015101945070Reveal · crackedENTRY DOOR CUT OUT REVEAL CRACKED, BETWEEN BS 303.9 - BS 312, BETWEEN STRINGER 6L - 7L. R & R REVEAL IAW SRM & DWG.SDR SWAA2015101544942Angle · crackedKEEL BEAM T ANGLE CRACKED AT BS 639. R & R T ANGLE IAW SRM & DWG.SDR SWAA2015100844727Flap Track · corrodedRIGHT WING NR 7 FLAP TRACK UPPER AFT MOUNT PAD CORRODED. R & R FLAP TRACK IAW AMM.SDR SWAA2015100744668Doubler · crackedSTUB BEAM WEB DOUBLER CRACKED, AT BS 639, BBL 45.5. R & R DOUBLER IAW DWG.SDR SWAA2015092544299Fitting · corrodedRIGHT WING NR 5 FLAP TRACK CARRIAGE OTBD FWD ROLLER BUSHING BORE FITTING CORRODED. REPAIRED FITTING IAW EA & CMM.SDR SWAA2015092144074O-Ring · leakingAIR TURN BACK & DECLARED EMER. LOSE OF SYS A HYD SYS. R & R O RING IAW AMM.SDR SWAA2015110245653Spar · crackedLEFT WING REAR SPAR WEB, CRACKED ABOVE BEAM TO SPAR FITTING. REPAIRED SPAR WEB IAW ER & EA.SDR SWAA2015110245591Skin · crackedRIGHT MLG DOOR INNER SKIN CRACKED. R & R DOOR IAW AMM.SDR SWAA2015110245583Web · crackedWEB CRACKED AT BS 178, RBL 5.7. REPAIRED WEB IAW FAS EA.SDR SWAA2015110245582Web · crackedWEB CRACKED AT BS 178, RBL 5.7. REPAIRED WEB IAW SRM.SDR SWAA2015102945483Frame · crackedFRAME INNER CHORD CRACKED AT BS 639, BETWEEN STRINGER 14R - 18R. REPAIRED FRAME IAW EA.SDR SWAA2015102845435Frame · crackedFRAME CRACKED AT BS 344, STRINGER 6L. REPAIRED FRAME IAW EO & EA.SDR SWAA2015102745395Frame · crackedRIGHT BODY FRAME INNER CHORD CRACKED AT BS 616, FOURTH FASTENER FROM THE FLOORBEAM. REPAIRED CHORD IAW EA.SDR SWAA2015102645304Skin · crackedSKIN CRACKED AT BS 178, LBL 5.7. REPAIRED SKIN IAW SRM.SDR SWAA2015102245235Scuff Plate · crackedFORWARD CARGO AFT CORNER SCUFF PLATE, CRACKED AT LOWER FUSELAGE. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2015101945069Channel · crackedFORWARD CARGO COMPARTMENT, FLOOR STRUCTURE CHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO RBL 24.75. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015101945044Attach Angle · crackedL1 DOOR SURROUND STRUCTURE, AFT FRAME, AFT INTERCOSTAL ATTACH ANGLE CRACKED AT STRINGER 11L. R & R ANGLE IAW DWG & SRM.SDR SWAA2015101945036Crease Beam · crackedCREASE BEAM WEB CRACKED AT BS 616. R & R CREASE BEAM WEB IAW SRM.SDR SWAA2015101945035Hinge · crackedKEEL BEAM PANEL, HINGE AT LOWER FUSELAGE CRACKED AT BS 663.75. R & R HINGE IAW SRM & DWG.SDR SWAA2015101644993Scuff Plate · crackedFORWARD CARGO COMPARTMENT, CTR SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2015101644992Scuff Plate · crackedFORWARD CARGO COMPARTMENT, AFT CORNER SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2015092844311Channel · crackedFORWARD CARGO COMPARTMENT CHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.75. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015092144111Charger · brokenFORWARD EMER LIGHT BATTERY CHARGER M1674 BROKEN. R & R CHARGER IAW MM.SDR SWAA2015092144100Light · inoperativeR1 DOOR EXTERIOR EMER EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SWAA2015091844045Skin · delaminatedRIGHT WING INBD AFT FLAP, LOWER SURFACE DELAMINATED AT OTBD END. R & R AFT FLAP IAW AMM.SDR SWAA2015121447052Spoiler · looseLEFT WING, INBD GND SPOILER LOOSE. R & R SPOILER IAW AMM.SDR SWAA2015110245590Flap · crackedRIGHT WING LE KRUEGER FLAP AREA, CRACKED ON BS 208. REPAIRED KRUEGER FLAP IAW SRM.SDR SWAA2015102645348Frame · corrodedAFT CARGO FRAME, CORRODED AT BS 867, BL 0. REPAIRED FRAME IAW SRM.SDR SWAA2015102645341Skin · delaminatedRIGHT HORIZONTAL STABILIZER ELEVATOR UPPER SKIN DELAMINATED AT STATION 102. REPAIRED SKIN IAW SRM.SDR SWAA2015102645340Skin · delaminatedRIGHT HORIZONTAL STABILIZER ELEVATOR UPPER SKIN DELAMINATED AT STATION 53.5. REPAIRED SKIN IAW SRM.SDR SWAA2015102345273Glowstrip · deterioratedAFT CABIN STRIP PHOTO LUMINESCENT FLOOR PROXIMITY LIGHTING DETERIORATED. R & R STRIP IAW AMM.SDR SWAA2015102145206Lens · crackedL1 DOOR OVERHEAD EXIT SIGN LENS CRACKED. R & R LENS IAW AMM.SDR SWAA2015102145202Lens · crackedR2 DOOR OVERHEAD EXIT SIGN LENS CRACKED. R & R LENS IAW AMM.SDR SWAA2015102145201Lens · crackedR1 DOOR OVERHEAD EXIT SIGN LENS CRACKED. R & R LENS IAW AMM.SDR SWAA2015101945038Stringer · corrodedAFT CARGO STRINGER CORRODED, BETWEEN BS 847 - 867, STRINGER 24R. R & R STRINGER IAW SRM & DWG.SDR SWAA2015101644979Skin · crackedFUSELAGE SKIN CRACKED, BETWEEN BS 500C+13.5 TO BS 500C+14.5, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2015101444896Reveal · crackedL1 DOOR CUT OUT REVEAL CORNER CRACKED, BETWEEN BS 328 - 344. R & R CORNER IAW SRM & DWG.SDR SWAA2015100744670Door Sill · corrodedC2 DOOR CUT OUT UPPER SILL WEB CORRODED IN BAY, AFT OF DOOR DAMPER. R & R WEB IAW DWG.SDR SWAA2015100744669Seat Track · corrodedSEAT TRACK CORRODED AT BS 515, RBL 24. R & R SEAT TRACK IAW SRM & DWG.SDR SWAA2015092844331Shear Tie · corrodedSHEAR TIE CORRODED AT BS 867, BETWEEN STRINGER 27L - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015092544285Frame · corrodedAFT CARGO FRAME ANGLE CORRODED AT BS 947, BETWEEN STRINGER 26R - 25R. R & R ANGLE IAW SRM.SDR SWAA2015092544284Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947, BETWEEN STRINGER 26R - 25R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015091844042Flap · delaminatedLEFT WING, OTBD AFT FLAP TE DELAMINATED IN CTR OF FLAP. R & R AFT FLAP IAW AMM.SDR SWAA2015091844041Slat · delaminatedRIGHT WING NR 5 LE SLAT DELAMINATED ON INBD & OTBD CORNERS. R & R NR 5 SLAT IAW MM.SDR SWAA2015091844040Slat · delaminatedLEFT WING NR 2 LE SLAT DELAMINATED ON OTBD CORNER. R & R NR 2 SLAT IAW AMM.SDR SWAA2015091743980Skin · crackedL1 DOOR INTERIOR SKIN, JUST BELOW DOOR TORQUE TUBE CUT OUT FWD SIDE CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015091743979Strap · crackedFLOORBEAM WEB STRAP CRACKED AT BS 312. REPAIRED STRAP IAW SRM.SDR SWAA2015091743978Lens · brokenFORWARD GALLEY RT SIDE EMER EXIT LIGHT LENS COVER BROKEN. R & R SIGN ASSEMBLY IAW MM.SDR SWAA2015102945516Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 747, STRINGER 25L. R & R SHEAR TIE IAW SRM.SDR SWAA2015102945511Skin · crackedLEFT WING FIXED LE SKIN CRACKED AT KRUEGER FLAP SEAL DOOR CUT OUT AT BS 208. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4