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 SWAA2016012548352Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 328, STRINGER 22R. R & R CLIP IAW SRM.SDR SWAA2016012248305Skin · crackedRIGHT WING INSPAR SKIN, CRACKED AT WBL 175 AT FASTENER HOLE REAR SPAR. REPAIRED SKIN IAW SRM.SDR SWAA2016012048208Spoiler · brokenRIGHT WING NR 5 GND SPOILER, OTBD MAIN ATTACH LUG BROKEN. R & R GND SPOILER IAW MM.SDR SWAA2016012048197Lens · crackedLEFT EMER EXIT SIGN LOWER LIGHT LENS CRACKED. R & R LENS IAW AMM.SDR SWAA2016022549422Spar · crackedLEFT WING AFT SPAR, REAR SPAR UPPER CHORD HOLE, CRACKED ABOUT 7 O'CLOCK POSITION, LOCATED INBD OF RSS 224.14, HOLE 5. REPAIRED CHORD IAW EA.SDR SWAA2016022549421Spar · crackedLEFT WING AFT SPAR, REAR SPAR WEB HOLE, CRACKED ABOUT 7 O'CLOCK POSITION, LOCATED INBD OF RSS 224.14, HOLE 5. REPAIRED WEB IAW EA.SDR SWAA2016022549420Support Fitting · crackedLEFT WING AFT SPAR, AFT SUPPORT FITTING HOLE, CRACKED ABOUT 7 O'CLOCK POSITION, LOCATED INBD RSS 224.14, HOLE 5. REPAIRED FITTING IAW ER & EA.SDR SWAA2016022349311Spar · crackedRIGHT WING REAR SPAR, UPPER CHORD CRACKED, ABOUT 11 O CLOCK POSITION, LOCATED INBD OF RSS 224.14, HOLE NR 5. REPAIRED CHORD IAW EA.SDR SWAA2016022349329Spar · crackedRIGHT WING REAR SPAR, WEB HOLE CRACKED ABOUT 11 O CLOCK POSITION, LOCATED INBD OF RSS 224.14, HOLE NR 5. REPAIRED WEB IAW EA & ER.SDR SWAA2016022349328Support Fitting · crackedRIGHT WING AFT SPAR, AFT SUPPORT FITTING, HOLE CRACKED ABOUT 11 O CLOCK POSITION, LOCATED INBD OF RSS 224.14 HOLE NR 5. REPAIRED FITTING IAW ER & EA.SDR SWAA2016020248587Skin · crackedRIGHT WING UPPER SKIN CRACKED, APPROX 3.0" FWD OF REAR SPAR, LOCATED FWD OF FWD TRUNNION OF MLG, APPROX RSS 179. R & R SKIN IAW EA.SDR SWAA2016012848442Spar · crackedRIGHT WING AFT SPAR, REAR SPAR WEB HOLE CRACKED ABOUT 11 O'CLOCK POSITION, LOCATED AT SECOND HOLE INBD OF RSS 224.14. REPAIRED WEB IAW EA.SDR SWAA2016012148239Light · inoperativeAFT RT BULLNOSE LIGHT INOPERATIVE. REPAIRED LIGHT IAW AMM.SDR SWAA2016012148218Slide · out of positionL2 DOOR EMER EVAC SLIDE COVER OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016012048198Charger · inoperativeCEILING MOUNTED OVERWING EXIT SIGN INOPERATIVE. R & R CHARGER IAW AMM.SDR SWAA2016012048190Battery · dischargedCEILING MOUNTED OVERWING EXIT SIGN INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2016011948114Light · inoperativeAFT CTR EMER EXIT LIGHT INOPERATIVE. REPAIRED LIGHT IAW AMM.SDR SWAA2016022349320Support Fitting · crackedLEFT WING NR 4 GND SPOILER, INBD SUPPORT FITTING CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2016021048919Link · corrodedRIGHT MLG SWING LINK UPPER BORE CORRODED AT FWD POSITION. REPAIRED SWING LINK IAW EA.SDR SWAA2016020548736Fitting · crackedRT WING REAR SPAR AFT FITTING CRACKED AT RSS 224.14. REPAIRED FITTING IAW EA.SDR SWAA2016011948166Battery · dischargedNUMBER 1 FLASHLIGHT IN AFT GALLEY INOPERATIVE. R & R BATTERY PER AMM.SDR SWAA2016011948138Slide · unsecureR1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE IAW MT.SDR SWAA2016011948111Hinge Fitting · brokenLEFT WING INBD GND SPOILER HINGE FITTING BROKEN. R & R GND SPOILER IAW MM.SDR SWAA2016011948078Battery Pack · dischargedR1 DOOR SLIDE EXTERIOR EMER LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016021048913Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED, BETWEEN BS 616 TO 639, RBL 45.50 AT CTR WING BOX. R & R WEB IAW SRM & DWG.SDR SWAA2016020248605Flap Track · corrodedLEFT WING NR 2 FLAP TRACK A FRAME BORE CORRODED. REPAIRED FLAP TRACK IAW CMM.SDR SWAA2016013048467Skin · crackedSKIN CRACKED AT BS 469, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2016012648380Skin · crackedSKIN CRACKED AT BS 273, STRINGER 4L. REPAIRED SKIN IAW SRM.SDR SWAA2016012648379Skin · crackedSKIN CRACKED AT BS 361, STRINGER 6R. REPAIRED SKIN IAW EA.SDR SWAA2016012648378Skin · crackedSKIN CRACKED AT BS 364.5, STRINGER 5L. REPAIRED SKIN IAW EA.SDR SWAA2016012648377Skin · crackedSKIN CRACKED AT BS 469, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2016011848076Actuator · faultyDIVERSION, LT MLG UNSAFE LIGHT CAME ON DURING CLIMB, AFTER LEVER WAS AT OFF POSITION. NOTICEABLE ROLL YAW WAS ENCOUNTERED. R & R DOWNLOCK ACTUATOR IAW MM.SDR SWAA2016011848075Actuator · faultyDIVERSION, LT MLG UNSAFE LIGHT CAME ON DURING CLIMB, AFTER LEVER WAS AT OFF POSITION. NOTICEABLE ROLL YAW WAS ENCOUNTERED. R & R UPLOCK ACTUATOR IAW MM.SDR SWAA2016011848074Windshield · arcedDIVERSION & DECLARED EMER. R1 WINDSHIELD ARCED, THEN CRACKED AT FL 370. R & R R1 WINDSHIELD IAW AMM.SDR SWAA2016030849744Spar · crackedLEFT WING REAR SPAR WEB CRACKED, AT STATION RSS 224.14, AT UPPER FASTENER. REPAIRED WEB IAW EA.SDR SWAA2016030849743Spar · crackedRIGHT WING REAR UPPER SPAR CHORD CRACKED, AT RSS 224.4. REPAIRED CHORD IAW EA.SDR SWAA2016022949533Rib · crackedLEFT WING INNER UPPER RIB CHORD CRACKED, AT WBL 114, AFT SPAR AREA. REPAIRED CHORD IAW EA.SDR SWAA2016021649146Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 908, STRINGER 22R. R & R SPLICE IAW SRM & DWG.SDR SWAA2016021649104Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED, AT UPPER NR 5 FASTENER HOLE, RSS 223. REPAIRED CHORD IAW EA.SDR SWAA2016021649102Spar · crackedRIGHT WING REAR SPAR, WEB CRACKED AT UPPER 5 FASTENER HOLE, RSS 223. REPAIRED WEB IAW EA.SDR SWAA2016021649101Spar · crackedLEFT WING REAR SPAR, WEB CRACKED AT UPPER NR 5 FASTENER HOLE, RSS 223. REPAIRED WEB IAW EA.SDR SWAA2016021649089Spar · crackedLEFT WING REAR SPAR, UPPER CHORD CRACKED, AT UPPER NR 5 FASTENER HOLE, RSS 223. REPAIRED CHORD IAW EA.SDR SWAA2016021148976Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 847, STRINGER 21R. R & R SPLICE IAW SRM & DWG.SDR SWAA2016021148975Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 847, STRINGER 22R. R & R SPLICE IAW SRM & DWG.SDR SWAA2016021148974Stringer Splice · corrodedAFT CARGO COMPARTMENT, STRINGER SPLICE CORRODED AT BS 847, STRINGER 23R. R & R SPLICE IAW SRM & DWG.SDR SWAA2016021148968Support Fitting · crackedLEFT WING AFT SUPPORT FITTING CRACKED AT UPPER NR 5 FASTENER HOLE. R & R FITTING IAW SRM.SDR SWAA2016021048910Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 847, STRINGER 24R. R & R SPLICE IAW SRM & DWG.SDR SWAA2016021048909Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2016020948812Tie Clip · crackedAFT CARGO COMPARTMENT, TIE CLIP CRACKED AT BS 727A, STRINGER 25R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2016020948811Support · crackedAFT CARGO COMPARTMENT, ANGLE SUPPORT CRACKED AT BS 947.5, STRINGER 26L. R & R SUPPORT IAW SRM & DWG.
Back to Boeing 737-3H4