Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2013050815825Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 312+11, BETWEEN AND STR 28L TO STR 28R. REMOVED AND REPLACED WEB IAW SRM AND DRAWING.SDR SWAA2013050315546Slide · looseL2 DOOR SLIDE IS LOOSE. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA2013061717163Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016, STR 6R. REPAIRED WEB IAW EO.SDR SWAA2013061217096Bulkhead · crackedBULKHEAD WEB CRACKED BS 1016, STR 6R. REPAIRED WEB IAW EO AND EA.SDR SWAA2013061016943Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016, STR 6R. REPAIRED WEB IAW EA.SDR SWAA2013052916590Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016, STR 6L+ 2. REPAIRED WEB IAW SRM.SDR SWAA2013052816515Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016, STR 6L. REPAIRED WEB IAW SRM.SDR SWAA2013061016942Floorbeam · corrodedFLOORBEAM CORRODED AT BS 967, LBL 27.5. REPAIRED BEAM IAW EA.SDR SWAA2013060716881Rib · crackedLT WING LOWER CHORD RIB CRACKED AT WBL 135.5 BETWEEN S-2 AND S-3. REPAIRED RIB IAW SWA EA.SDR SWAA2013060716880Rib · crackedRT WING LOWER CHORD RIB CRACKED AT WBL 135.5 BETWEEN S-2 AND S-3. REPAIRED RIB IAW EA.SDR SWAA2013060716879Floorbeam · crackedFLOORBEAM WEB CRACKED AT BS 713, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013052816514Attach Angle · crackedATTACH CLIP CRACKED AT BS 348.2, STR 15L. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013060616832Frame · crackedFRAME CRACKED AT BS 294.5, STR 4L. REPAIRED FRAME IAW AND EA.SDR SWAA2013052916589Web · crackedWEB CRACKED AT BS. 294.5+2, RBL 55. R & R WEB IAW SRM AND DWG.SDR SWAA2013052816513Angle · corrodedDOOR Z ANGLE CORRODED BETWEEN BS 294.5 AND BS 344, RBL 61. R & R Z ANGLE IAW SRM AND DWG.SDR SWAA2013050915855Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013050915854Angle · crackedANGLE CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2013050615668Floorbeam · corrodedFLOORBEAM CORRODED AT BS 344, BL 0. REPAIRED BEAM IAW SRM.SDR SWAA2013060716878Fitting · crackedFWD GALLEY DOOR CUTOUT FITTING CRACKED AT BS 332.1, STR 8R. REPAIRED FITTING IAW EA.SDR SWAA2013060716877Frame · crackedFRAME CRACKED AT BS 277, STR 16L. REPAIRED WEB IAW EA.SDR SWAA2013060716876Frame · crackedFRAME WEB CRACKED AT BS 277, STR 16L. REPAIRED WEB IAW EA.SDR SWAA2013060316655Angle · crackedFWD ENTRY DOOR CUTOUT CRACKED ON AFT LOWER REVEAL AT BS 344, STR 17L. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013060316654Angle · crackedFWD ENTRY DOOR CUTOUT ANGLE CRACKED AT BS 348.2, BETWEEN STR 11L TO STR 12L. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013060316653Fitting · crackedFWD GALLEY DOOR CUTOUT CRACKED BETWEEN BS 291.5 TO BS 297, STR 8R. REPAIRED FITTING IAW EO AND EA.SDR SWAA2013052916588Panel · crackedNLG WHEEL WELL SIDE PANEL CRACKED AT BS 251.6, RBL 16. REPAIRED PANEL IAW SRM.SDR SWAA2013052916585Support Angle · crackedRIGHT WING NR 8 T/E SUPPORT ANGLE CRACKED LOCATED UNDER SURFACE. R & R FASTENERS IAW SRM AND DWG.SDR SWAA2013052816507Angle · crackedRIGHT WING T/E ANGLE CRACKED AT RSS 533 T/E AREA. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013052816512Panel · crackedNLG WHEEL WELL SIDE PANEL CRACKED AT BS 243.7, RBL 16. REPAIRED PANEL IAW SRM.SDR SWAA2013052816511Angle · corrodedDOOR Z ANGLE CORRODED BETWEEN BS 312 AND BS 344, LBL 59. R & R Z ANGLE IAW SRM.SDR SWAA2013052316423Skin · crackedSKIN CRACKED AT BS 827+15, STR 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013052216348Reveal · crackedR1 DOOR CUTOUT AFT UPPER REVEAL CRACKED AT BS 312+13, BETWEEN STR 7R TO STR 8R. R & R REVEAL IAW SRM AND DWG.SDR SWAA2013052216349Reveal · crackedL1 DOOR CUTOUT FWD UPPER REVEAL CRACKED AT BS 312, BETWEEN STR 6L TO STR 7L. R & R REVEAL IAW SRM AND DWG.SDR SWAA2013052016203Bulkhead · crackedNLG WHEEL WELL SIDE PANEL CRACKED AT BS 243.7 + 3.5, LBL 16. REPAIRED PANEL IAW SRM.SDR SWAA2013051516075Panel · crackedNLG WHEEL WELL SIDE PANEL CRACKED AT BS 243.7, LBL 16. REPAIRED PANEL IAW SRM.SDR SWAA2013051315937Angle · crackedANGLE CRACKED AT BS 291, BETWEEN STR 10R TO STR 11R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013050615667Skin · crackedL1 DOOR UPPER HINGE CUTOUT CRACKED. REMOVED AND REPLACED CUTOUT IAW SRM.SDR SWAA2013061016964Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STR 18A RT SIDE. REPAIRED FRAME IAW EA.SDR SWAA2013061016950Bulkhead · crackedAFT BULKHEAD, AFT SIDE DOME WEB CRACKED AT BS 1016, STR 15R. REPAIRED WEB IAW EO AND EA.SDR SWAA2013060316657Frame · corrodedFRAME CORRODED AT BS 482A, BETWEEN STR 28R AND STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA2013052216347Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 927 TO BS 947.5, BL0. R & R ANGLE IAW SRM AND DWG.SDR SWAA2013051315936Angle · crackedRIGHT WING FLAP TRACK T/E INTERNAL ANGLE CRACKED AT WBL 183.40. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013051315929Shear Tie · corrodedFRAME CORRODED AT BS 482B, STR 28L FWD CARGO COMPARTMENT. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2013050915867Retainer · crackedLEFT WING FLAP TRACK FAIRING SEAL RETAINER CRACKED ON ACCESS PANEL 3501L. REMOVED AND REPLACED RETAINER IAW SRM.SDR SWAA2013061016941Frame · crackedFRAME OUTBOARD CHORD CRACKED AT BS 727, STR 18A LT SIDE. REPAIRED FRAME IAW EA.SDR SWAA2013060716875Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 707 AND BS 709, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013060516801Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 667.5, LBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2013052916584Skin · crackedSKIN CRACKED AT BS 440+5, STR 26L. REPAIRED SKIN IAW SRM.SDR SWAA2013052916583Skin · crackedSKIN CRACKED AT BS 420+5.5, STR 26L. REPAIRED SKIN IAW SRM.SDR SWAA2013061016940Skin · crackedSKIN CRACKED AT BS 482B + 12, STR 16L. REPAIRED SKIN IAW EA.SDR SWAA2013060716874Skin Panel · corrodedKEEL BEAM SKIN PANEL CORRODED BETWEEN BS 616 AND BS 639, BL 0. R & R PANEL IAW EA.
Back to Boeing 737-5H4