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 SWAA2016020148546Angle · crackedMAIN WW COMPARTMENT, AFT BULKHEAD ANGLE CRACKED AT LBL 16. R & R ANGLE IAW SRM & DWG.SDR SWAA2016012548351Skin · crackedFUSELAGE SKIN CRACKED AT BS 390+3, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2016012548350Frame · crackedFRAME CRACKED AT BS 328, STRINGER 21R. REPAIRED FRAME IAW ACO.SDR SWAA2016012048200Fitting · crackedRIGHT WING SPAR FITTING CRACKED AT RSS 250. R & R FITTING IAW SRM & DWG.SDR SWAA2016011948146Bracket · crackedBULKHEAD CLOSE OUT BRACKET CRACKED, AT BS 727, RBL 5. R & R BRACKET IAW SRM.SDR SWAA2016011147862Battery Pack · dischargedLEFT OVERWING EMER LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016011147842Battery Pack · dischargedRIGHT OVERWING EMER LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2016030849741Spar · crackedLEFT WING REAR UPPER SPAR CHORD CRACKED, AT RSS 224.14. REPAIRED CHORD IAW EA.SDR SWAA2016022349324Crease Beam · crackedCENTER WING BOX SUPPORT, CREASE BEAM CHORD CRACKED, AT BS 616, RBL 63.5. REPAIRED CREASE BEAM IAW EA.SDR SWAA2016021849174Skin · crackedLEFT UPPER WING SKIN CRACKED, BETWEEN RSS 239 - 269, FROM TE. REPAIRED SKIN IAW EA.SDR SWAA2016021649114Skin · crackedRIGHT WING NR 6 EXTERNAL SKIN CRACKED, INBD EDGE LOWER SURFACE. REPAIRED SKIN IAW SRM.SDR SWAA2016021649113Skin · crackedRIGHT WING NR 2 SLAT EXTERNAL SKIN CRACKED, AT INBD EDGE LOWER SURFACE. REPAIRED SKIN IAW SRM.SDR SWAA2016020948840Skin · crackedRIGHT UPPER WING, REAR SPAR UPPER CHORD SKIN CRACKED AT RSS 266. REPAIRED SKIN IAW SRM.SDR SWAA2016020948809Stiffener · crackedVERTICAL STIFFENER REAR SPAR CRACKED AT BS 663.75, RBL 6.15 AT CTR WING BOX. R & R STIFFENER IAW SRM.SDR SWAA2016020548740Skin · crackedRT UPPER WING UPPER REAR SPAR CHORD SKIN CRACKED AT RSS 240. REPAIRED SKIN IAW EA.SDR SWAA2016013048469Spar · crackedRIGHT WING REAR SPAR, WEB FASTENER HOLE CRACKED AT RSS 224, NR 5 HOLE. REPAIRED WEB IAW EA.SDR SWAA2016013048463Light · brokenAFT GALLEY EMER EXIT INDICATOR LIGHT BROKEN. R & R LIGHT IAW AMM.SDR SWAA2016012648398Fairing · delaminatedRIGHT WING NR 6 FLAP TRACK FAIRING DELAMINATED AT TAIL CONE. REPAIRED FAIRING IAW SRM.SDR SWAA2016011548014Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN LBL 8 TO RBL 10. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016011548003Skin · crackedSKIN CRACKED AT BS 430+7, STRINGER 6R. REPAIRED SKIN IAW SRM.SDR SWAA2016011347955Buttstrap · crackedBUTT SPLICE STRAP CRACKED AT BS 360, BETWEEN STRINGER 5R - 7R. R & R BUTT STRAP IAW SRM & DWG.SDR SWAA2016010847816Cover · looseFORWARD ENTRY EMER EXIT FLOOR LIGHT PLASTIC COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2016010847815Light · dimFLIGHT COMPARTMENT EMER DOME LIGHT DIM. RELAMPED LIGHT IAW AMM.SDR SWAA2016010847807Light · inoperativeAFT ENTRY DOOR EMER EXIT SIGN BULB INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2016021148971Skin · delaminatedRIGHT TAIL CONE EXTERNAL SKIN DELAMINATED. REPAIRED SKIN IAW SRM.SDR SWAA2016020948839Skin · crackedLEFT WING UPPER SKIN, REAR SPAR CHORD CRACKED AT RSS 254, AFT FASTENER ROW, FASTENER HOLE. REPAIRED SKIN IAW SRM & EA.SDR SWAA2016020948838Skin · crackedLEFT WING UPPER SKIN, REAR SPAR CHORD CRACKED AT RSS 250, AFT FASTENER ROW, FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SWAA2016020948837Skin · crackedLEFT WING UPPER SKIN, REAR SPAR CHORD CRACKED AT RSS 249, AFT FASTENER ROW, FASTENER HOLE. REPAIRED SKIN IAW SRM & EA.SDR SWAA2016020948836Skin · crackedLEFT WING UPPER SKIN REAR SPAR CHORD CRACKED AT RSS 239, AFT FASTENER ROW, FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SWAA2016020348632Angle · crackedANGLE CRACKED, BETWEEN BS 500D - 520, ON INLET DUCT THE RAM AIR INTERNAL AREA, RT AT LOWER FUSELAGE. R & R ANGLE IAW SRM & DWG.SDR SWAA2016012848445Fitting · crackedRIGHT AFT MLG FITTING CRACKED IN LOWER FITTING HOLE. R & R FITTING IAW DWG & EA.SDR SWAA2016012048199Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED, BETWEEN BS 698 - 717, RBL 24.50. REPAIRED WEB IAW EA.SDR SWAA2016010747773Lens · looseFORWARD ENTRY DOOR EXIT SIGN ON WALL, LENS COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2016011948083Stiffener · corrodedFORWARD BULKHEAD WW DOOR STOP STIFFENER CORRODED AT BS 227, LBL 3.5. R & R STIFFENER IAW DWG & SRM.SDR SWAA2016021649112Skin · crackedRIGHT WING UPPER SKIN, CRACKED AFT SPAR ROW, BETWEEN RSS 224 - 270. REPAIRED SKIN IAW EA.SDR SWAA2016021649111Fitting · crackedLEFT MLG FITTING CRACKED IN NR 5 HOLE. REPAIRED FITTING IAW EA.SDR SWAA2016012048216Hanger Assy · corrodedLEFT MLG BORE, CORRODED ON WALKING BEAM HANGER. REPAIRED BORE IAW CMM.SDR SWAA2016011147875Support Fitting · corrodedINTERCOSTAL SUPPORT CLIP CORRODED AT BS 794, RBL 6. R & R CLIP IAW SRM & DWG.SDR SWAA2016011147828Channel · crackedRIGHT WING TE LOWER PANEL SUPPORT CHANNEL CRACKED JUST OTBD NR 2 PYLON. REPAIRED CHANNEL IAW EA.SDR SWAA2016010547641Sign · looseRIGHT OVERWING EXIT SIGN LOOSE. SECURED SIGN IAW MM.SDR SWAA2016011948145Bracket · crackedRIGHT WING BRACKET, COMMON TO UPPER SPAR CHORD CRACKED, AT RSS 235. R & R BRACKET IAW DWG & SRM.SDR SWAA2016011948144Spar · crackedLEFT WING BRACKET, COMMON TO UPPER SPAR CHORD CRACKED, AT RSS 235. REPAIRED CHORD IAW DWG & EA.SDR SWAA2016011548002Skin · crackedSKIN CRACKED AT BS 360, STRINGER 5R. REPAIRED SKIN IAW EA.SDR SWAA2016011147874Attach Fitting · crackedINTERCOSTAL ATTACH CLIP BELOW THE FLOOR TO SIDEWALL SUPPORT, CRACKED AT BS 500A, LBL 25. R & R ATTACH CLIP IAW SRM & DWG.SDR SWAA2016011147848Light · inoperativeRIGHT AFT OVERWING EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016010447620Retainer · looseL1 DOOR SLIDE GIRT BAR LT LATCH RETAINER LOOSE. SECURED LATCH RETAINER IAW MM.SDR SWAA2016010447619Charger · inoperativeEMERGENCY LIGHT BETWEEN ROW 21 & 22 INOPERATIVE. R & R BATTERY CHARGER IAW MM.SDR SWAA2016010447621Lens · looseFORWARD ENTRY EXIT LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2016010447618Battery · dischargedEMERGENCY LIGHT BATTERY M01669 INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2016010447613Flashlight · inoperativeAFT EMER FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT IAW MM.
Back to Boeing 737-3H4