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 SWAA2015042939120Structure · crackedLOWER FWD HOLE CHORD CRACKED AT BS 727, STRINGER 18A. REPAIRED CHORD IAW ER & EA.SDR SWAA2015042939119Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A LT. REPAIRED CHORD IAW EA & ER.SDR SWAA2015042038654Web · crackedRIGHT NOSE WW WEB CRACKED AT BS 258.5. REPAIRED WEB IAW SRM.SDR SWAA2015040138059Skin · delaminatedLEFT WING OTBD AFT FLAP LOWER SURFACE SKIN DELAMINATED AT THE TE JUST INBD OF THE INBD FAIRING RUB STRIPS. REPAIRED AFT FLAP IAW SRM.SDR SWAA0300030137971Web · crackedRIGHT NOSE WW WEB CRACKED AT BS 247.2. REPAIRED WEB IAW SRM.SDR SWAA2015030937250Light · inoperativeOVERHEAD ENTRY DOOR EMER EXIT SIGN INOPERATIVE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015030937210Cover · looseFORWARD LOWER ENTRY EXIT LIGHT COVER LOOSE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015043039176Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+13.5, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2015043039175Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+14.5, STRINGER 2R. REPAIRED SKIN IAW EO & EA.SDR SWAA2015043039149Frame · crackedUPPER AFT FASTENER HOLE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT AT 1:00 & 7:00 O'CLOCK. REPAIRED CHORD IAW EA.SDR SWAA2015043039148Frame · crackedLOWER FWD FASTENER HOLE FRAME OTBD CHORD CRACKED AT BS 727, BETWEEN STRINGER 18A LT AT 1:00 & 7:00 O'CLOCK. REPAIRED CHORD IAW EA.SDR SWAA2015043039147Frame · crackedUPPER FWD FASTENER HOLE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A LT SIDE AT 1:00 O'CLOCK. REPAIRED CHORD IAW EA.SDR SWAA2015043039146Frame · crackedLOWER AFT FASTENER HOLE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A RT AT 3:00 & 9:00 O'CLOCK. REPAIRED CHORD IAW EA.SDR SWAA2015043039145Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, BETWEEN STRINGER 17R - 27R, AT 2:00 & 7:00 O'CLOCK. REPAIRED CHORD IAW EA.SDR SWAA2015041338452Skin · crackedR2 DOOR LOWER HINGE SKIN CUT OUT LOWER FWD CORNER CRACKED. REPAIRED SKIN IAW EA & ER.SDR SWAA2015041338451Channel · crackedCHANNEL CRACKED AT BS 359, STRINGER 8L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015031837567Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 5L. R & R CLIP IAW SRM.SDR SWAA2015031837566Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 908, STRINGER 7L. R & R CLIP IAW SRM.SDR SWAA2015031237382Support Angle · crackedVERTICAL SUPPORT ANGLE CRACKED AT BS 727D, STRINGER 27R. R & R ANGLE IAW SRM.SDR SWAA2015031237381Support Angle · crackedVERTICAL SUPPORT ANGLE CRACKED AT BS 727D, STRINGER 27L. R & R ANGLE IAW SRM.SDR SWAA2015042438918Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, LBL 5. REPAIRED BEAM IAW EA.SDR SWAA2015042438917Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.5, LBL 0. REPAIRED BEAM IAW EA.SDR SWAA2015042038653Former · crackedRIGHT WING TO BODY FAIRING FORMER CRACKED AT BS 540, UPPER OTBD END. R & R FORMER IAW SRM & DWG.SDR SWAA2015041538513Bulkhead · crackedBULKHEAD CHORD CRACKED AT BS 178, RBL 17. REPAIRED CHORD IAW SRM & EA.SDR SWAA2015041538538Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 178, RBL 17. REPAIRED WEB IAW SRM & EA.SDR SWAA2015041338450Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 767 - 787. R & R WEB IAW SRM & DWG.SDR SWAA2015041338449Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 500A - 500B. R & R WEB IAW SRM & DWG.SDR SWAA2015041338448Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED BETWEEN BS 420 - 440. REPAIRED WEB IAW SRM & DWG.SDR SWAA2015040838286Crease Beam · corrodedR2 DOOR INNER CREASE BEAM CHORD CORRODED. REPAIRED CHORD IAW SRM & DWG.SDR SWAA2015033037963Crease Beam · corrodedR1 DOOR CREASE BEAM INNER CHORD CORRODED. R & R CREASE BEAM IAW DWG & SRM.SDR SWAA2015031037306Bottle · low pressureR1 DOOR EMER EVAC SLIDE BOTTLE PRESS LOW. R & R SLIDE IAW MT.SDR SWAA2015030937257Battery Pack · dischargedLEFT EMER LIGHT INOPERATIVE BETWEEN ROW 3 TO 6. R & R BATTERY PACK IAW AMM.SDR SWAA2015030937251Lens · looseRIGHT BULLNOSE EMER LIGHT LENS LOOSE AT ROW 5. SECURED LENS IAW AMM.SDR SWAA2015030937209Landing Gear · faultyUPON LANDING GEAR EXTENSION LT MLG LIGHT REMAINED RED, NOSE & RT GEAR WERE GREEN. CYCLED GEAR & GOT THREE GREEN. R & R LT MLG ASSEMBLY IAW MT.SDR SWAA2015042839066Spar · crackedRIGHT WING UPPER REAR SPAR CHORD CRACKED AT RSS 228. REPAIRED CHORD IAW ER & EA.SDR SWAA2015042839065Spar · crackedLEFT WING UPPER REAR SPAR CHORD CRACKED AT RSS 226. REPAIRED CHORD IAW ER & EA.SDR SWAA2015032337680Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 597, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2015031237378Channel · crackedFLOOR SUPPORT CHANNEL CRACKED AT BS 787, STRINGER 27L. REPAIRED CHANNEL IAW SRM.SDR SWAA2015031237375Angle · crackedANGLE CHANNEL CRACKED AT BS 787, STRINGER 27L. REPAIRED ANGLE IAW SRM.SDR SWAA2015030937275Angle · crackedLEFT WING UPPER TE TO FLAP FAIRING ANGLE CRACKED OTBD OF NR 3 FLAP JACKSCREW. R & R ANGLE IAW SRM.SDR SWAA2015030937256Flap · delaminatedRIGHT WING OTBD AFT FLAP DELAMINATED BETWEEN MIDDLE TRACKS. R & R AFT FLAP IAW AMM.SDR SWAA2015030937255Panel · delaminatedRIGHT WING NR 8 GND SPOILER PANEL DELAMINATED. R & R NR 8 GND SPOILER IAW AMM.SDR SWAA2015030937253Slat · delaminatedRIGHT WING NR 5 SLAT INBD END DELAMINATED. R & R NR 5 SLAT IAW AMM.SDR SWAA2015030937252Fairing · crackedRIGHT WING UPPER FIXED TE PANEL SUPPORT ANGLE OTBD OF INBD FLAP, OTBD TRACK FAIRING CRACKED AFT END. R & R FAIRING IAW SRM.SDR SWAA2015030937208Lens · out of adjustLEFT EMER EXIT SIGN LENS COVER OUT OF ADJUSTMENT AT ROW 11. ADJUSTED LENS IAW AMM.SDR SWAA2015031737553Strap · deterioratedLEFT OVERWING EMER EXIT HATCH ESCAPE STRAP HOOK TOW COVER HAD DETERIORATED VELCRO. R & R STRAP ASSEMBLY IAW AMM.SDR SWAA2015031737552Strap · deterioratedRIGHT OVERWING EMER EXIT HATCH ESCAPE STRAP HOOK TOW COVER HAD DETERIORATED VELCRO. R & R STRAP ASSEMBLY IAW AMM.SDR SWAA2015031637463Skin Panel · crackedKEEL BEAM SKIN PANEL CRACKED AT BS 684, LBL 5. REPAIRED SKIN IAW SRM.SDR SWAA2015031137334Skin Panel · crackedEXTERNAL SKIN PANEL BETWEEN LT & RT MAIN GEAR CRACKED AT BS 684, RBL 5. REPAIRED SKIN IAW SRM.SDR SWAA2015030537149Bracket · crackedLEFT WING UPPER TE PANEL CRACKED BRACKET AT THE OTBD SIDE OF PYLON. R & R BRACKET IAW SRM.
Back to Boeing 737-3H4