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 SWAA2015060840464Skin · crackedFUSELAGE SKIN CRACKED AT STATION 777.5, STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2015060240283Slat · delaminatedNUMBER 5 LE SLAT DELAMINATED AT INBD UPPER CORNER. R & R SLAT IAW MM.SDR SWAA2015060240282Slat · delaminatedNUMBER 4 LE SLAT DELAMINATED AT INBD UPPER CORNER. R & R SLAT IAW MM.SDR SWAA2015071341833Skin · crackedR1 DOOR LOWER CORNER BEAR STRAP SKIN CRACKED AT BS 312+15.5", STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071341832Skin · crackedR2 DOOR SKIN LOWER FWD CORNER CUT OUT CRACKED AT BS 947.5+10", STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071041787Skin · crackedR1 DOOR EXTERNAL BEAR STRAP CUT OUT SKIN CRACKED AT BS 312+15, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015061740827Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7. REPAIRED WEB IAW EA.SDR SWAA2015061040527Web · crackedFUSELAGE WEB CRACKED AT STATION 727 BETWEEN RBL 38 & RBL 45. R & R WEB IAW SRM.SDR SWAA2015060340317Structure · crackedFUSELAGE CHORD CRACKED AT STATION 1066, BETWEEN STRINGER 6L & 7L. REPAIRED CHORD IAW SRM.SDR SWAA2015052940185Skin · crackedFUSELAGE SKIN CRACKED AT FWD RT CORNER OF GND SERVICE ACCESS PANEL. REPAIRED SKIN IAW EA.SDR SWAA2015052940184Slat · delaminatedNUMBER 2 LE SLAT OTBD UPPER CORNER DELAMINATED. R & R SLAT ASSEMBLY IAW MM.SDR SWAA2015052940183Lens · missingEXIT LIGHT LENS MISSING AT 23 ABC. INSTALLED LENS IAW MM.SDR SWAA2015052840113Slide · out of positionR1 DOOR EMER EVAC SLIDE GIRT BAR AFT HOLD CLAMP OUT OF POSITION. REPOSITIONED SLIDE IAW SIP.SDR SWAA2015071041786Skin · crackedR1 DOOR FUSELAGE SKIN CRACKED AT BS 328, STRINGER 17R. REPAIRED SKIN IAW EO & EA.SDR SWAA2015070841535Skin · crackedLEFT UPPER CORNER OF WINDOW POST C - D SKIN LOCATED CRACKED AT BS 219.8. REPAIRED SKIN IAW SRM.SDR SWAA2015060840467Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 707, LBL 24.8. REPAIRED FLOORBEAM IAW EA.SDR SWAA2015060240290Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 908, STRINGER 21R. R & R CLIP IAW SRM.SDR SWAA2015052740094Sign · looseAFT EMER EXIT SIGN JUST OTBD OF FLIGHT ATTENDANT SEAT LOOSE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015052740058Sign · looseAFT CTR EMER EXIT SIGN LOOSE. SECURED SIGN IAW MM.SDR SWAA2015071341831Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT RSS 215.97+5.9", AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015071341830Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT RSS 215.97+5.9", AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015071041718Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+7, RBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2015071041717Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+3, RBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2015070941687Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75, LBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2015070941686Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+7, LBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2015061740826Strap · crackedSPLICE STRAP CRACKED AT BS 360, STRINGER 3R. REPAIRED STRAP IAW EA.SDR SWAA2015060140247Lens · missingEXIT LIGHT LENS MISSING AT ROW 20 DEF. INSTALLED LENS IAW MM.SDR SWAA2015052740092Light · inoperativeRIGHT EMER EXIT BULLNOSE LIGHT INOPERATIVE AT ROW 20. REPAIRED LIGHT IAW MM.SDR SWAA2015052639992Battery Pack · dischargedRIGHT BULLNOSE EMER LIGHT INOPERATIVE AT ROW 20. R & R BATTERY PACK IAW MM.SDR SWAA2015052639991Battery Pack · dischargedLEFT BULLNOSE EMER LIGHT INOPERATIVE AT ROW 22. R & R BATTERY PACK IAW MM.SDR SWAA2015052539962Handle · looseR2 DOOR ASSIST HANDLE LOOSE. SECURED HANDLE IAW MM.SDR SWAA2015061640778Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4L. REPAIRED SPLICE IAW EA.SDR SWAA2015060140252Flap · delaminatedLEFT WING INBD FORE FLAP DELAMINATED. R & R FLAP IAW MM.SDR SWAA2015062641189Tie Clip · crackedTIE CLIP CRACKED AT STATION 947.5, STRINGER 24L. R & R CLIP IAW SRM.SDR SWAA2015052740085Sign · unsecureFORWARD EXIT SIGN FELL OFF. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2015052640050Skin · crackedLEFT WING LOWER SKIN CRACKED ABOVE OTBD PANEL MID SPAR FITTING. REPAIRED SKIN IAW EA.SDR SWAA2015052640035Sign · looseRIGHT OVERWING EMER EXIT SIGN LOOSE. SECURED SIGN IAW AMM.SDR SWAA2015062341099Carriage · corrodedLEFT WING NR 2 CARRIAGE A FRAME ATTACH POINT BOLT HOLE CORRODED. R & R CARRIAGE IAW SRM.SDR SWAA2015061640793Glowstrip · damagedFORWARD CABIN PHOTO LUMINESCENT STRIP DAMAGED. R & R STRIP IAW AMM.SDR SWAA2015060340330Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 360, STRINGER 5L. R & R CLIP IAW SRM.SDR SWAA2015060340329Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 360, STRINGER 2L. R & R CLIP IAW SRM.SDR SWAA2015052640051Light · inoperativeLEFT EMER LIGHT INOPERATIVE AT ROW 18. RELAMPED LIGHT IAW AMM.SDR SWAA2015052640036Skin · delaminatedLEFT WING NR 4 SLAT INBD TE LOWER SKIN DELAMINATED. REPAIRED SKIN IAW EA.SDR SWAA2015052640034Flap · delaminatedLEFT WING INBD AFT FLAP TE DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2015052640028Bracket · crackedR2 DOOR SLIDE UPPER FWD BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2015052640027Lens · crackedRIGHT OVERWING EMER EXIT LIGHT LENS CRACKED. R & R LENS IAW MM.SDR SWAA2015052640026Flashlight · inoperativeFORWARD OTBD EMER FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW AMM.SDR SWAA2015052239925Lug · brokenLEFT WING NR 4 GND SPOILER OTBD ATTACH LUG BROKEN. R & R SPOILER IAW AMM DWG.SDR SWAA2015061240648Intercostal · crackedFOUND AN INTERCOSTAL CRACKED AT BS 277 - 292, STRINGER 11R. REPAIRED THE INTERCOSTAL IAW EA.SDR SWAA2015061040518Skin · crackedLEFT WING INBD FIXED LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4