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 SWAA2015060240287Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 807, STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2015060240286Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT STATION 907, STRINGER 23L. R & R SPLICE IAW SRM.SDR SWAA2015052940221Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 662, RBL 27.8. REPAIRED BEAM IAW EA.SDR SWAA2015052940215Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT STATION 907, STRINGER 21R. R & R SPLICE IAW SRM.SDR SWAA2015052840155Strap · looseRIGHT EMER EXIT HATCH STRAP HOOK STOW POUCH VELCRO LOOSE. R & R STRAP IAW SOPM.SDR SWAA2015052840152Stringer Splice · corrodedAFT CARGO BAY ON STRINGER END SPLICE UPPER FLANGE CORRODED AT BS 851.5, STRINGER 23R. R & R SPLICE IAW SRM & DWG.SDR SWAA2015052840151Stringer Splice · corrodedAFT CARGO BAY ON STRINGER END SPLICE UPPER FLANGE CORRODED AT BS 851.5, STRINGER 24R. R & R SPLICE IAW SRM & DWG.SDR SWAA2015052740091Attach Angle · crackedRIGHT WING AILERON COVE WEB ATTACH ANGLE CRACKED AT RSS 545. R & R ANGLE IAW SRM.SDR SWAA2015051139552Slide · out of adjustR1 DOOR EMER SLIDE PACK OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW AMM.SDR SWAA2015062241024Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT MLG AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015062241023Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT THE MLG AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015061940974Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664, RBL 17. REPAIRED DECK IAW EA.SDR SWAA2015061740810Crease Beam · crackedCREASE BEAM INNER CHORD CRACKED AT BS 616, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2015061640799Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD VERTICAL FLANGE CRACKED BETWEEN BS 666 TO 670, LBL 24.5, AT OVAL HOLE UPPER AFT CORNER. REPAIRED BEAM IAW EA.SDR SWAA2015061640692Frame · corrodedFRAME SHEAR TIE CORRODED AT BS 500C, LBL 9. R & R FRAME IAW SRM & DWG.SDR SWAA2015061040522Support Fitting · corrodedRIGHT WING REAR SPAR OTBD SUPPORT FITTING CORRODED ABOVE MLG. REPAIRED FITTING IAW EA.SDR SWAA2015060340337Rib · crackedRIGHT WING RIB CRACKED AT WBL 114, STRINGER 2. REPAIRED RIB IAW EA.SDR SWAA2015052740090Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, RBL 7. REPAIRED SHEAR TIE IAW SRM & DWG.SDR SWAA2015052740089Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, LBL 5. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015051839794Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 500A - 500B. REPAIRED CREASE BEAM IAW SRM & DWG.SDR SWAA2015051339632Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 787 - 807. R & R WEB IAW SRM & DWG.SDR SWAA2015051139505Lug · damagedLEFT WING NR 4 GND SPOILER INBD ATTACH LUG DAMAGED. R & R NR 4 SPOILER IAW AMM.SDR SWAA2015061740809Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED ALONG REAR SPAR BETWEEN STAB STATION 157 TO 166. REPAIRED SKIN IAW EA.SDR SWAA2015060340335Floorbeam · crackedFLOORBEAM CRACKED AT STATION 616, LBL 45.5. REPAIRED BEAM IAW EA.SDR SWAA2015051139550Lock · looseR1 DOOR AFT SLIDE LOCK LOOSE. SECURED LOCK ASSEMBLY IAW SIP.SDR SWAA2015050139528Lens · looseRIGHT BULLNOSE EMER EXIT LIGHT LENS LOOSE AT ROW 12. SECURED LENS IAW MM.SDR SWAA2015051139526Flap · delaminatedLEFT WING INBD AFT FLAP DELAMINATED ON INBD END. R & R AFT FLAP IAW AMM.SDR SWAA2015051139525Slat · crackedRIGHT WING NR 6 SLAT TE CRACKED. R & R NR 6 SLAT IAW AMM.SDR SWAA2015051139524Web · crackedR1 DOOR LOWER WEB AFT CORNER CRACKED ALONG THE EDGE OF THE STOP FITTING. R & R DOOR IAW AMM & EA.SDR SWAA2015050839453Cover · crackedRIGHT EMER EXIT DOOR RELEASE HANDLE COVER CRACKED. R & R COVER IAW SIP.SDR SWAA2015070141289Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED IN HOLES COMMON TO MLG AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015061040526Structure · crackedLEFT FUSELAGE INNER CHORD CRACKED AT STATION 616, WL 205. REPAIRED CHORD IAW EA.SDR SWAA2015060940498Frame · crackedLEFT FUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW EA.SDR SWAA2015060540426Support Fitting · crackedLEFT WING REAR SPAR UPPER CHORD MLG SUPPORT FITTING CRACKED. REPAIRED FITTING IAW EA.SDR SWAA2015050539323Slide · out of adjustR1 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2015050739417Lens · looseFORWARD CEILING EXIT SIGN LENS LOOSE. R & R LENS IAW AMM.SDR SWAA2015052139908Structure · crackedRIGHT MAIN WW LIP CRACKED AT BS 717. R & R LIP IAW SRM & DWG.SDR SWAA2015051839756Shear Tie · crackedSHEAR TIE CRACKED AT BS 500D, BETWEEN STRINGER 27L - 28L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015051839755Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 28L - 28R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015050639350Lug · damagedRIGHT WING NR 5 INBD GND SPOILER OTBD ACTUATOR LINK LUG DAMAGED. R & R SPOILER IAW AMM.SDR SWAA2015061840908Fitting · crackedLEFT WING REAR SPAR TO INTERNAL WALKING BEAM FITTING CRACKED AT RSS 219. R & R FITTING IAW SRM.SDR SWAA2015052740093Attach Angle · crackedLEFT WING TE BULKHEAD SEAL WBL 209 LOWER ATTACH ANGLE CRACKED. REPAIRED ANGLE IAW SRM & DWG.SDR SWAA2015052239950Angle · crackedRIGHT WING TE BULKHEAD SEAL ANGLE CRACKED AT WBL 209. REPAIRED ANGLE IAW SRM.SDR SWAA2015051439662Skin · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED AT 36.5" INBD OF OTBD EDGE ON UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015051439661Skin · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED 43.5" INBD OF OTBD EDGE ON UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015050539307Cover · missingRIGHT OVERWING EXIT SIGN COVER MISSING. INSTALLED COVER IAW MM.SDR SWAA2015050539301Wire · damagedLEFT DOOR LOWER EMER EXIT LIGHT INOPERATIVE. R & R WIRE IAW SWPM & WDM.SDR SWAA2015050539320Generator · faultyDIVERSION, DURING TAKEOFF EQUIPMENT COOLING LIGHT, OFF, LIGHT CAME ON. FLIGHT ATTENDANT SMELLED A BAD SMELL IN CABIN. R & R NR 1 ENG GEN IAW MM.SDR SWAA2015061940931Spar · damagedLEFT WING UPPER SKIN TO AFT SPAR UPPER CHORD FWD DAMAGED AT RSS 233. REPAIRED CHORD IAW EA.SDR SWAA2015061940930Skin · crackedLEFT WING UPPER SKIN AT REAR SPAR AREA CRACKED AT RSS 267. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4