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 SWAA2015060840452Arm · crackedLEFT MLG BEAM ARM CRACKED. R & R BEAM ARM IAW MM.SDR SWAA2015060440364Lens · looseFORWARD GALLEY EXIT LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015070941690Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 787, BETWEEN STRINGER 26L TO 27L. REPAIRED FRAME IAW SRM.SDR SWAA2015070941689Frame · crackedAFT CARGO COMPARTMENT FRAME CRACKED AT BS 727D, BETWEEN STRINGER 26L TO 27L. REPAIRED FRAME IAW SRM.SDR SWAA2015070841517Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 277, STRINGER 14R. R & R WEB IAW SRM & DWG.SDR SWAA2015070841516Stiffener · crackedAFT CARGO COMPARTMENT STIFFENER CRACKED AT BS 727, STRINGER 27L. R & R STIFFENER IAW SRM.SDR SWAA2015070641300Channel · corrodedCHANNEL CORRODED AT BS 727D+5, LBL 3.0. REPAIRED CHANNEL IAW EA.SDR SWAA2015070641299Stiffener · crackedAFT CARGO COMPARTMENT STIFFENER CRACKED AT BS 727, STRINGER 27R. R & R STIFFENER IAW SRM & DWG.SDR SWAA2015061840880Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947.5, BETWEEN STRINGER 26L TO 27L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015061640797Strap · crackedFORWARD CABIN FLOOR STRUCTURE STRAP CRACKED BETWEEN BS 294.5+10 TO 344+5, RBL 34. R & R STRAP IAW SRM & DWG.SDR SWAA2015061640796Strap · crackedFORWARD CABIN FLOOR STRUCTURE STRAP CRACKED BETWEEN BS 294.5+10 TO 344+5, LBL 48. R & R STRAP IAW SRM & DWG.SDR SWAA2015061640795Strap · crackedFORWARD CABIN FLOOR STRUCTURE STRAP CRACKED BETWEEN BS 294.5+10 TO 344+5, LBL 10. R & R STRAP IAW SRM & DWG.SDR SWAA2015061640794Strap · crackedFORWARD CABIN FLOOR STRUCTURE STRAP CRACKED BETWEEN BS 294.5+10 TO 344+5, BL 0. R & R STRAP IAW SRM & DWG.SDR SWAA2015061240652Channel · corrodedFOUND A CHANNEL CORRODED AT BS 727D+5, LBL 8.1. REPAIRED THE CHANNEL IAW EA.SDR SWAA2015060440362Battery Pack · dischargedR2 DOOR EXTERNAL EMER LIGHTS INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2015060340321Lens · looseR2 DOOR EXIT LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015060340319Skin · crackedL1 DOOR INNER SKIN CRACKED AT LOWER HINGE CUT OUT. REPAIRED SKIN IAW EA.SDR SWAA2015070641309Angle · crackedFORWARD CARGO COMPARTMENT CLIP ANGLE CRACKED AT BS 400, STRINGER 26R. R & R CLIP ANGLE IAW SRM & DWG.SDR SWAA2015070641307Angle · crackedFORWARD CARGO COMPARTMENT CLIP ANGLE CRACKED AT BS 540, LBL 2. R & R CLIP ANGLE IAW SRM & DWG.SDR SWAA2015061940973Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED BETWEEN BS 887 - 907, RBL 46. R & R ANGLE IAW SRM & DWG.SDR SWAA2015061940972Angle · crackedAFT CARGO COMPARTMENT ANGLE OF WEB CRACKED AT BS 947.5, BETWEEN STRINGER 24L - 25L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015061740808Angle · crackedANGLE CRACKED BETWEEN BS 927 TO 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2015060340320Sign · looseEXIT SIGN NEXT TO RT OVERWING DOOR LOOSE. SECURED SIGN IAW MM.SDR SWAA2015070941688Keelbeam · corrodedFORWARD CARGO COMPARTMENT KEEL BEAM CORRODED AT BS 500D+7.5, STRINGER 28L. REPAIRED KEEL BEAM IAW SRM & DWG.SDR SWAA2015060240274Slide · looseR1 DOOR SLIDE OUT OF POSITION. REPOSITIONED R1 DOOR SLIDE IAW AMM.SDR SWAA2015060140229Lens · missingEXIT LIGHT LENS MISSING AT AFT GALLEY. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015070841536Floorbeam · crackedFLOORBEAM CRACKED AT BS 344, LBL 9. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2015070841515Skin · crackedRIGHT WING FIXED LE UPPER SKIN CRACKED AT WBL 157. REPAIRED SKIN IAW EA.SDR SWAA2015070841538Frame · crackedFRAME CRACKED AT BS 440, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2015070841537Web · crackedFORWARD CARGO COMPARTMENT WEB CRACKED AT BS 440, BETWEEN STRINGER 26R - 25R. R & R WEB IAW SRM & DWG.SDR SWAA2015061740807Floorbeam · crackedFLOORBEAM WEB CRACKED AT BS 639, RBL 45.5. REPAIRED WEB IAW SRM.SDR SWAA2015061640760Bracket · crackedRIGHT WING TE BRACKET CRACKED AT WS 531. REPLACED BRACKET IAW SRM & DWG.SDR SWAA2015061640752Support Fitting · crackedFORWARD CARGO COMPARTMENT SUPPORT CLIP CRACK AT BS 380, STRINGER 26R. R & R CLIP IAW SRM & DWG.SDR SWAA2015061640751Support Fitting · crackedFORWARD CARGO COMPARTMENT SUPPORT CLIP CRACK AT BS 380, STRINGER 26L. R & R CLIP IAW SRM & DWG.SDR SWAA2015060840465Skin · delaminatedRIGHT WING INBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FLAP IAW SRM.SDR SWAA2015071041789Floorbeam · corrodedFLOORBEAM UPPER CHORD FLANGE AT CORRODED AT BS 986.5, BETWEEN RBL 5 - 43. REPAIRED CHORD IAW EO & EA.SDR SWAA2015070641305Web · corrodedWEB CORRODED BETWEEN BS 847 - 867, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015061240644Skin · crackedFOUND THE FUSELAGE SKIN CRACKED AT BS 960, STRINGER 17R. REPAIRED THE SKIN IAW EA.SDR SWAA2015061040520Angle · corrodedFUSELAGE Z ANGLE CORRODED AT STATION 986.5+4, RBL 47, WL 207. R & R ANGLE IAW SRM.SDR SWAA2015060240281Light · inoperativeEMERGENCY LIGHTS ON ROW 20 DEF INOPERATIVE. R & R LIGHTS ASSEMBLY IAW MM.SDR SWAA2015060240280Light · inoperativeEMERGENCY LIGHTS ON ROW 18 ABC - 24 DEF INOPERATIVE. R & R LIGHTS ASSEMBLY IAW MM.SDR SWAA2015060140234Lens · brokenEXIT SIGN LENS BROKEN AT FWD FLIGHT ATTENDANT`S SEAT. R & R LENS IAW MM.SDR SWAA2015071441910Skin · crackedR1 DOOR AFT LOWER CORNER SKIN CRACKED AT BS 312+15, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071341834Skin · crackedR2 DOOR CUT OUT SKIN CRACKED AT BS 947.5+12, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071041788Skin · crackedL2 DOOR SKIN CRACKED AT BS 947.5+12, STRINGER 17L, LOWER FWD CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2015070941681Skin · crackedAFT ENTRY DOOR LOWER FWD CORNER, SKIN CRACKED BETWEEN BS 947.5 TO 967+10, BETWEEN STRINGER 16L TO 19L. REPAIRED SKIN IAW SRM.SDR SWAA2015070941664Slat · delaminatedLEFT WING, NR 2 LEADING SLAT DELAMINATED AT OTBD UPPER CORNER. REPAIRED NR 2 SLAT IAW EA.SDR SWAA2015061240643Skin · crackedFOUND THE FUSELAGE SKIN CRACKED AT L2 DOOR FWD LOWER CORNER CUTOUT. REPAIRED THE SKIN IAW EA.SDR SWAA2015060940516Floorbeam · crackedFLOORBEAM CRACKED AT STATION 698 - 717, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2015060940515Floorbeam · crackedFLOORBEAM CRACKED AT STATION 708, LBL 24.8. REPAIRED BEAM IAW EA.
Back to Boeing 737-3H4