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 SWAA2014071429943Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM UPPER CHORD HORIZONTAL FLANGE CRACKED AT BS 666.5, LBL 24.5. REPAIRED FLANGE IAW EO & EA.SDR SWAA2014071429942Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664, LBL 20. REPAIRED WEB IAW EO & EA.SDR SWAA2014071429941Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664, LBL 7.5. REPAIRED WEB IAW EO & EA.SDR SWAA2014071429940Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664, LBL 5. REPAIRED WEB IAW EO & EA.SDR SWAA2014070929825Access Panel · crackedLEFT ENG NACELLE STRUT ACCESS PANEL 5764L CRACKED. REPAIRED PANEL IAW EO & EA.SDR SWAA2014070829747Skin · crackedSKIN CRACKED AT BS 787+16, STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2014070829734Skin · crackedSKIN CRACKED AT BS 787+2.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014070829704Skin · crackedSKIN CRACKED AT BS 787+16.5, STRINGER 20L. REPAIRED SKIN IAW EA.SDR SWAA2014070729662Skin · crackedSKIN CRACKED AT BS 360+15, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2014070729661Skin · crackedSKIN CRACKED AT BS 344+2, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2014070729660Skin · crackedSKIN CRACKED AT BS 827+4, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014070329608Skin · crackedFUSELAGE SKIN CRACKED AT STATION 787+16, STRINGER 22R. REPAIRED SKIN IAW SRM.SDR SWAA2014070329607Skin · crackedFUSELAGE SKIN CRACKED AT STATION 847+15, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014070129555Support Angle · crackedRIGHT PYLON ACCESS PANEL SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014062329332Support Angle · crackedNUMBER 1 ENG STRUT TORQUE BOX INBD SUPPORT ANGLE CRACKED AT INTERNAL AREA ACCESS PANEL N5758L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014062329331Support Angle · crackedNUMBER 1 ENG STRUT TORQUE BOX SUPPORT ANGLE CRACKED AT INTERNAL AREA ACCESS PANEL N5757L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014062329330Support Angle · crackedRIGHT PYLON SUPPORT ANGLE CRACKED AT INTERNAL AREA OF STRUT TORQUE BOX AT ACCESS PANEL 5857R INBD SIDE. R & R ANGLE IAW SRM & DWG.SDR SWAA2014061629071Fitting · crackedRIGHT PYLON FWD UPPER STRUT STRUCTURE SUPPORT OF ACCESS PANEL 5847R CLIP CRACKED. R & R CLIP IAW SRM & DWG.SDR SWAA2014070829746Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A LT FWD LOWER FASTENER HOLE OF INSPECTION AREA. REPAIRED CHORD IAW EA.SDR SWAA2014070729659Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT AT FWD LOWER FASTENER HOLE OF INSPECTION AREA. REPAIRED CHORD IAW EA.SDR SWAA2014070729658Stringer · crackedSTRINGER CRACKED AT BS 727, STRINGER 18A LT AT FWD LOWER FASTENER HOLE OF INSPECTION AREA. REPAIRED STRINGER IAW EA.SDR SWAA2014070729657Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A LT AT FWD LOWER FASTENER HOLE OF INSPECTION AREA. REPAIRED CHORD IAW EA.SDR SWAA2014060228600Skin · crackedFUSELAGE SKIN CRACKED AT BS 780, STRINGER 19L. REPAIRED SKIN IAW SRM.SDR SWAA2014060228599Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+13, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014060628788Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016, STRINGER 15L. REPAIRED WEB IAW ER & EA.SDR SWAA2014052728358Skin · crackedRIGHT WING LE CRACKED AT NR 5 SLAT OTBD AUXILIARY TRACK CUT OUT CRACKED. REPAIRED CUT OUT IAW SRM.SDR SWAA2014060928861Skin · crackedCHEM MILL SKIN CRACKED BETWEEN BS 931 TO BS 931.7, STRINGER 22L. REPAIRED SKIN IAW ER & EA.SDR SWAA2014060628787Skin · crackedSKIN CRACKED AT BS 914, STRINGER 4L. REPAIRED SKIN IAW EA.SDR SWAA2014060628786Skin · crackedCHEM MILL SKIN CRACKED AT BS 482A+4, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014060528716Skin · crackedCHEM MILL SKIN CRACKED BETWEEN BS 798.5 TO BS 800.6, STRINGER 22L. REPAIRED SKIN IAW SRM.SDR SWAA2014060528715Skin · crackedSKIN CRACKED AT BS 360, STRINGER 1L. REPAIRED SKIN IAW SRM.SDR SWAA2014060528714Skin · crackedCHEM MILL SKIN CRACKED AT BS 393, STRINGER 15L. REPAIRED SKIN IAW EA.SDR SWAA2014052728373Battery Pack · dischargedL1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014052728372Slide · looseL1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2014052328309Lens · looseRIGHT OVERWING EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014052128222Mount Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE MOUNT BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2014071530023Strip · crackedNUMBER 2 PYLON ACCESS PANEL 58720 CRACKED NUTPLATE STRIP OTBD SIDED. REPAIRED STRIP IAW EA.SDR SWAA2014051928114Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014051928115Mount · damagedR2 DOOR EMERGENCY EVAC SLIDE FWD SLIDE MOUNT DAMAGED. R & R MOUNT IAW SRM.SDR SWAA2014051528044Slide · deployedL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED. R & R SLIDE IAW MT. CORRECTED STATION.SDR SWAA2014051427919O-Ring · failedDIVERSION, SYS A HYD FAILURE INFLIGHT. FOUND FAILED O RING ON A SYS MODULE. R & R O RING ON A SYS MODULE IAW SIP.SDR SWAA2014051427918Smoke Detector · faultyDIVERSION, DECLARED EMERGENCY AT FL320 OVER PMD FWD LAVATORY SMOKE DETECTOR WENT OFF. R & R LAVATORY SMOKE DETECTOR IAW AMM.SDR SWAA2014051428007Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 824+7.25 TO BS 827+7.575, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2014051428006Spoiler · delaminatedRIGHT WING NR 6 SPOILER DELAMINATED. R & R NR 6 SPOILER IAW AMM.SDR SWAA2014051327907Skin · crackedFUSELAGE SKIN CRACKED AT STATION 827 TO STATION 834, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2014050727743Skin · crackedSKIN CRACKED AT BS 332, STRINGER 4L. REPAIRED SKIN IAW SRM.SDR SWAA2014043027559Skin · crackedFUSELAGE SKIN CRACKED AT BS 907+4, STRINGER 22R. REPAIRED SKIN IAW SRM.SDR SWAA2014042227305Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2014041427100Attach Angle · crackedLEFT WING STABILIZER BAR ATTACH ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014041127027Slide · brokenL1 DOOR ESCAPE SLIDE LATCH BROKEN. R & R SLIDE ASSEMBLY IAW MM.
Back to Boeing 737-5H4