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 SWAA2015032637855Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 277 - 291.5, STRINGER 10R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015031337395Skin · delaminatedNUMBER 2 LE SLAT DELAMINATED AT UPPER SKIN. REPAIRED NR 2 SLAT IAW EA.SDR SWAA2015041738615Web · crackedWEB CRACKED AT BS 492.4, BETWEEN STRINGER 26R - 25R. REPLACED WEB IAW SRM & DWG.SDR SWAA2015041538516Web · crackedWEB CRACKED BETWEEN BS 460 - 480, STRINGER 26L. R & R WEB IAW DWG & SRM.SDR SWAA2015041438507Shear Tie · corrodedSHEAR TIE CORRODED AT BS 986.5, BETWEEN STRINGER 27R TO 27L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015041438506Shear Tie · corrodedSHEAR TIE CORRODED AT BS 967, BETWEEN STRINGER 26L - 27L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015041438505Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 772, LBL 12.5. REPAIRED BEAM IAW EA & SRM.SDR SWAA2015041438504Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED BEAM IAW EA & SRM.SDR SWAA2015041438503Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED BEAM IAW EA & SRM.SDR SWAA2015041438502Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM IAW EA.SDR SWAA2015041438501Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED AT BS 772, RBL 3. REPAIRED BEAM IAW SRM.SDR SWAA2015040838284Pressure Deck · crackedWHEEL WELL PRESS DECK CRACKED AT BS 663+2, RBL 40. REPAIRED DECK IAW EA.SDR SWAA2015040638152Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 19L - 21L. REPAIRED FRAME IAW SRM.SDR SWAA2015032637886Intercostal · corrodedWEB CORRODED AT BS 993, STRINGER 21R. R & R INTERCOSTAL SAM.SDR SWAA2015032337696Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 540 BETWEEN LBL 0.07 TO RBL 24.50. R & R ANGLE IAW SRM & DWG.SDR SWAA2015031337392Light · brokenR1 DOOR EMER EXIT LIGHT BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015031237384Light · inoperativeLEFT EMER EXIT LIGHT INOPERATIVE AT ROW 11. RELAMPED LIGHT IAW AMM.SDR SWAA2015050539300Skin · crackedSKIN CRACKED AT BS 312+13, STRINGER 4L. REPAIRED SKIN IAW SRM.SDR SWAA2015050139202Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 20L - 21L AT 9 O`CLOCK VIEW FROM FWD SIDE. REPAIRED FRAME IAW EA.SDR SWAA2015043039177Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STRINGER 20R - 21R AT 3 O'CLOCK VIEW FROM FWD SIDE. / REPAIRED FRAME IAW SRM.SDR SWAA2015042939121Support Channel · corrodedNUMBER 3 VHF ANTENNA SUPPORT CHANNEL CORRODED AT BS 727D+10, LBL 1.5. REPAIRED CHANNEL IAW ER & EA.SDR SWAA2015042438914Tab · corrodedRIGHT WING TE AILERON CONTROL TAB INBD HINGE AFT ROD, END CORRODED. R & R TAB IAW CMM.SDR SWAA2015042438864Light · inoperativeLEFT EMER EXIT SIDEWALL PANEL SIGN BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2015042038675Skin · crackedFORWARD ENTRY DOOR FUSELAGE SKIN CUT OUT CRACKED BETWEEN BS 328 - 360, BETWEEN STRINGER 15L TO 19L. REPAIRED SKIN IAW EA.SDR SWAA2015041638593Skin · crackedSKIN CRACKED AT BS 360+14, STRINGER 8L. REPAIRED SKIN IAW EO & EA.SDR SWAA2015041538537Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2015041538536Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2015041338398Skin · crackedL2 DOOR SKIN CUT OUT UPPER AFT CORNER CRACKED AT BS 986.5+2, STRINGER 7L. REPAIRED SKIN IAW SRM.SDR SWAA2015041338443Angle · crackedRIGHT WING TE REAR SPAR AILERON ACCESS PANEL 7418R,TE STRUCTURE OTBD AFT VERTICAL ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2015041338442Angle · crackedLEFT WING TE AFT SPAR ACCESS AILERON PANEL 7218L,TE OTBD AFT VERTICAL ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2015040938329Skin · crackedL2 DOOR SKIN CUT OUT CRACKED AT BS 986.5+2, STRINGER 7L. REPAIRED SKIN IAW SRM.SDR SWAA2015040638163Fairing · crackedLEFT WING AILERON TAB MAST FAIRING CRACKED. R & R FAIRING IAW DWG.SDR SWAA2015032737930Lens · deterioratedRIGHT OVERWING EXIT SIDEWALL LIGHT LENS DETERIORATED. R & R LENS IAW MM.SDR SWAA2015032737925Lens · deterioratedLEFT OVERWING EXIT SIDEWALL LIGHT LENS DETERIORATED. R & R LENS IAW MM.SDR SWAA2015032637854Lens · brokenLEFT EMER EXIT SIGN LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2015031237386Battery · dischargedAFT CABIN EMER FLASHLIGHT INOPERATIVE. R&R BATTERY IAW AMM.SDR SWAA2015031237385Lens · unsecureL1 DOOR EMER EXIT LIGHT LENS FELL OFF. REINSTALLED LENS IAW SIP.SDR SWAA2015031237383Lens · missingL1 DOOR EMER EXIT LIGHT LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2015031137340Power Supply · faultyFORWARD CABIN EMER EXIT LIGHT FAULTY. R & R BATTERY SUPPLY IAW AMM.SDR SWAA2015031137339Spoiler · delaminatedLEFT WING NR 3 SPOILER PANEL DELAMINATED. R & R NR 3 SPOILER IAW AMM.SDR SWAA2015031137338Flap · delaminatedLEFT WING OTBD TE AFT FLAP DELAMINATED OTBD EDGE. R & R AFT FLAP IAW AMM.SDR SWAA2015031137337Skin · crackedLEFT WING NR 2 SLAT SKIN CRACKED LOWER SURFACE AT INBD AUXILIARY TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2015031137336Skin · crackedLEFT WING NR 1 SLAT SKIN CRACKED AT LOWER SURFACE AT INBD AUXILIARY TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2015031137335Angle · crackedRIGHT WING RSS 545, 9" AFT RT SIDE DRY BAY OTBD ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015042138735Frame · crackedFRAME OTBD CHORD CRACKED AT BS 7, STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2015040638162Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, BETWEEN STRINGER 18R - 27R, FWD LOWER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2015032637885Support · corrodedFORWARD CARGO BAY LT FLOOR TO SIDEWALL SUPPORT CORRODED AROUND SEVERAL NUTPLATE HOLES BETWEEN BS 490 - 500D. R & R SUPPORT IAW SRM.SDR SWAA2015031137345Latch · brokenCAPTAIN ROPE ACCESS DOOR LATCH BROKEN. R & R LATCH IAW SIP.SDR SWAA2015031037307Battery · dischargedFORWARD INBD FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2015050439245Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664+1.750, LBL 45.50. REPAIRED WEB IAW EA.
Back to Boeing 737-3H4