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 SWAA2016031149802Strap · corrodedAFT PIT STRAP ON TOP OF FRAME CORRODED, AT BS 847, STRINGER 26R. R & R CLIP IAW SRM.SDR SWAA2016030449652Attach Angle · corrodedAFT CARGO VERTICAL ATTACH ANGLE CORRODED AT BS 794, STRINGER 28R. R & R ANGLE IAW SRM & DWG.SDR SWAA2016030449646Tie Clip · crackedTIE CLIP CRACKED AT BS 727C, STRINGER 23R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2016022349288Skin · crackedFUSELAGE SKIN CRACKED AT BS 908+5.5, STRINGER 10R. REPAIRED SKIN IAW SRM.SDR SWAA2016022949511Fitting · crackedCLIP CRACKED AT BS 908, STRINGER 1R. R & R CLIP IAW SRM.SDR SWAA2016022649510Fitting · crackedCLIP CRACKED AT BS 908, STRINGER 1L. R & R CLIP IAW SRM.SDR SWAA2016022349291Light · inoperativeR1 DOOR SLIDE LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016022349290Skin · crackedFUSELAGE SKIN CRACKED AT BS 837+2, STRINGER 6L. REPAIRED SKIN IAW SRM.SDR SWAA2016022349289Skin · crackedFUSELAGE SKIN CRACKED AT BS 294.5+3, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2016022349287Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+2, STRINGER 8R. REPAIRED SKIN IAW SRM.SDR SWAA2016022349285Lens · looseFORWARD ENTRY DOOR EMER EXIT LIGHT LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2016022349325Indicator · malfunctionedJUST PRIOR TO TOP OF DESCENT AT FL350 HEARD A NOISE, SOUNDED LIKE ARCING, FOLLOWED BY STRONG ODOR. DID NOT GET ANY APPRECIABLE SMOKE & SMELL DISSIPATED. R & R WEATHER INDICATOR IAW AMM.SDR SWAA2016040650633Skin · crackedFORWARD GALLEY SERVICE DOOR CUT OUT UPPER FWD CORNER SKIN CRACKED, BETWEEN BS 277 - 313, BETWEEN STRINGER 6R - 15R. REPAIRED SKIN IAW EA.SDR SWAA2016031549928Floor Support · corrodedFLOOR SUPPORT CORRODED AT STATION 950 - 990, WL 208. R & R SUPPORT IAW SRM.SDR SWAA2016031549910Spoiler · brokenNUMBER 5 GND SPOILER HINGE ATTACH POINT BROKEN. R & R SPOILER IAW MM.SDR SWAA2016022649472Support · damagedRIGHT WING NR 7 OTBD FLAP, INBD A FRAME SUPPORT, AFT INBD CORNER DAMAGED. R & R SUPPORT IAW SOPM.SDR SWAA2016022349339Cover · looseFORWARD ENTRY EMER EXIT SIGN COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2016022349295Flashlight · brokenFORWARD GALLEY LAVATORY FLASHLIGHT BASE BROKEN. R & R FLASHLIGHT BASE IAW SRM.SDR SWAA2016022349286Sign · looseMID CABIN EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2016022349272Lens · out of adjustFORWARD LOWER CEILING AFT EXIT LENS OUT OF ADJUSTMENT. ADJUSTED LENS IAW AMM.SDR SWAA2016022349271Slide · out of positionL2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016022349270Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016021949225Light · inoperativeL1 EMER LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016032850288Support Fitting · crackedLEFT MLG AFT SUPPORT FITTING NR 5 HOLE CRACKED. R & R FITTING IAW EA.SDR SWAA2016032850287Support Fitting · crackedRIGHT MLG AFT SUPPORT FITTING NR 5 HOLE CRACKED. R & R FITTING IAW EA.SDR SWAA2016032150014Support Fitting · crackedRIGHT WING MLG BEAM AFT SUPPORT FITTING CRACKED. REPAIRED FITTING IAW EA.SDR SWAA2016031850003Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 670, RBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2016031850002Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 670, RBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2016031749971Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 970. REPAIRED BEAM IAW SRM.SDR SWAA2016031549906Stiffener · crackedSTIFFENER CRACKED AT MAIN CABIN BELOW FLOOR, AT STATION 727, RBL 46. R & R STIFFENER IAW SRM.SDR SWAA2016031549924Fitting · crackedLEFT WING REAR SPAR MLG BEAM FITTING CRACKED. R & R FITTING IAW SRM.SDR SWAA2016030749673Bracket · wornL2 DOOR SLIDE MOUNTING NUTPLATE FWD & AFT AREA WORN. R & R BRACKET ASSEMBLY IAW SRM.SDR SWAA2016030749672Bracket · wornR2 DOOR SLIDE MOUNTING NUTPLATE FWD & AFT WORN. R & R BRACKETS IAW SRM.SDR SWAA2016030349604Strap · crackedE & E COMPARTMENT, LOWER CABIN FLOOR, STABILIZER STRAP CRACKED AT BS 328, RBL 32. REPAIRED STRAP IAW SRM.SDR SWAA2016030249574Shear Tie · corrodedSHEAR TIE CORRODED AT BS 967, BETWEEN STRINGER 18R - 19R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016022949509Frame · crackedFRAME CRACKED AT BS 328, STRINGER 21R. R & R FRAME IAW EA.SDR SWAA2016022649447Frame · crackedFRAME ANGLE CRACKED AT BS 328, BETWEEN STRINGER 20R - 21R. REPAIRED FRAME IAW EA.SDR SWAA2016022349268Power Supply · inoperativeENTRY DOOR EXTERIOR EMER LIGHT INOPERATIVE. R & R POWER SUPPLY IAW MM.SDR SWAA2016022349267Skin · crackedLEFT WING NR 1 SLAT, LOWER SKIN CRACKED, AT TWO EACH FASTENERS AT INBD AUXILIARY TRACK AREA. REPAIRED SKIN IAW SRM.SDR SWAA2016040650640Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 218.5. REPAIRED WEB IAW EA.SDR SWAA2016040650636Splice · crackedLEFT WING SPAR UPPER CHORD SPLICE CRACKED AT RSS 221.5. REPAIRED SPLICE IAW EA.SDR SWAA2016040450579Support Angle · crackedLEFT WING INBD UPPER FIXED TE PANEL, INBD SUPPORT ANGLE CRACKED AT AFT ATTACH HOLE. REPAIRED ANGLE IAW DWG.SDR SWAA2016040450559Splice · crackedRIGHT WING REAR SPAR UPPER CHORD SPLICE CRACKED ON FASTENER HOLE RSS 221.5. REPAIRED SPLICE IAW EA.SDR SWAA2016032850245Frame · crackedFORWARD CARGO PIT FRAME CRACKED AT BS 500C, BETWEEN STRINGER 20L - 21L. REPAIRED FRAME IAW SRM.SDR SWAA2016031849986Frame · crackedFUSELAGE FRAME CRACKED AT STATION 500D, STRINGER 20L - 21L. REPAIRED FRAME IAW SRM.SDR SWAA2016031749970Frame · crackedFUSELAGE FRAME CRACKED AT STATION 500D, BETWEEN STRINGER 20L & 21L. REPAIRED FRAME IAW SRM.SDR SWAA2016030449651Door · delaminatedFUSELAGE DOOR OTBD HINGE DELAMINATED AT BS 340, STRINGER 2R. REPAIRED DOOR IAW SRM.SDR SWAA2016021849186Light · inoperativeCENTER CABIN OVERHEAD BINS EMER LIGHT INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2016021849182Wedge · delaminatedRIGHT WING NR 5 SLAT WEDGE DELAMINATED AT OTBD END. REPAIRED NR 5 SLAT IAW AMM.SDR SWAA2016021849158Cover · looseRIGHT OVERWING EMER EXIT LIGHT COVER LOOSE. SECURED COVER IAW SIP.
Back to Boeing 737-3H4