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 SWAA2015050839461Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 540, STRINGER 22L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042038670Skin · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED AT INBD EDGE LOWER SKIN. REPAIRED AFT FLAP IAW SRM.SDR SWAA2015041538545Cover · brokenL1 DOOR EMER EXIT DOOR SIGN COVER BROKEN. R & R COVER IAW AMM.SDR SWAA2015041038351Battery Pack · dischargedRIGHT AFT CABIN EMER LIGHT INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2015040938322Flap · delaminatedLEFT WING TE AFT FLAP DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2015050439280Skin · crackedFUSELAGE SKIN CRACKED AT BS 188, ON A B LINE. R & R SKIN IAW SRM & DWG.SDR SWAA2015041438509Attach Angle · crackedBULKHEAD ATTACH ANGLE CRACKED BS 947, STRINGER 22R. R & R ANGLE IAW DWG & SRM.SDR SWAA2015041338384Skin · crackedL1 DOOR CRACKED AT LOWER HINGE INTERIOR SKIN AT VERTICAL STIFFENER. R & R DOOR IAW MM.SDR SWAA2015040938321Stop Fitting · crackedL1 DOOR UPPER AFT STOP FITTING CRACKED. R & R DOOR IAW MM.SDR SWAA2015050839460Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 947.5, STRINGER 22L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015050139205Stringer · crackedSTRINGER CRACKED AT BS 380, STRINGER 15R. REPAIRED STRINGER IAW SRM.SDR SWAA2015042438885Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 277 - 291.5, BETWEEN STRINGER 12R - STR 11R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015042438863Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STRINGER 21R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015042438862Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STRINGER 22R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015040738237Battery · dischargedAFT EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2015041738616Tie Clip · crackedTIE CLIP CRACKED AT BS 685, STRINGER 2R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015041438486Skin · crackedR1 DOOR SKIN CUT OUT CRACKED AT BS 244.5, STRINGER 14R, LOWER HINGE. REPAIRED CUT OUT IAW SRM.SDR SWAA2015040638161Fastener · missingL1 DOOR EMER EVAC SLIDE COVER AFT GIRT BAR STOW HOOK ATTACH FASTENER MISSING. INSTALLED FASTENER IAW MM.SDR SWAA2015052940219Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT RSS 215.97+6.5. REPAIRED CHORD IAW EA.SDR SWAA2015041538525Structure · crackedRIGHT HORIZONTAL STABILIZER CRACKED JUST FWD OF LOWER AFT SPAR APPROX STAB STATION 97. REPAIRED STABILIZER IAW SRM.SDR SWAA2015041538524Skin · crackedSKIN CRACKED AT BS 294.5, STRINGER 14R, STATION 294.5. REPAIRED SKIN IAW SRM.SDR SWAA2015041038346Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT FWD RT CORNER OF CONDITIONED AIR DOOR CUT OUT. REPAIRED SKIN IAW ER & EA.SDR SWAA2015052539972Channel · crackedSPLICE CHANNEL CRACKED AT BS 360, STRINGER 7R. REPAIRED CHANNEL IAW EO & EA.SDR SWAA2015051939820Angle · crackedCHORD SPLICE ANGLE CRACKED AT BS 540, BETWEEN STRINGER 21R - 22R. R & R ANGLE IAW SRM & EA.SDR SWAA2015051939819Angle · crackedSPLICE ANGLE CRACKED AT BS 540 BETWEEN STRINGER 20L - 21L. R & R ANGLE IAW SRM & EA.SDR SWAA2015050539303Support Bracket · crackedRIGHT WING NR 8 FAIRING TRACK INTERNAL SUPPORT BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2015041638604Plate · brokenG1 GALLEY EMER LIGHT BASE PLATE BROKEN. R & R LIGHT IAW AMM.SDR SWAA2015041338404Fairing · crackedLEFT WING NR 3 FLAP TRACK FAIRING CRACKED AT UPPER FIXED TE PANEL. REPAIRED FAIRING IAW SRM & DWG.SDR SWAA2015040738238Lens · unsecureRIGHT OVERWING EMER EXIT LENS FELL OFF. REPAIRED LENS IAW AMM.SDR SWAA2015040738188Skin · crackedL1 DOOR CRACKED AT LOWER HINGE BOX INTERIOR SKIN & VERTICAL FRAME. REPAIRED SKIN IAW EA.SDR SWAA2015040638096Skin · crackedR1 DOOR SKIN LOWER HINGE CUT OUT CRACKED AT BS 294.5, STRINGER 14R. REPAIRED SKIN IAW SRM.SDR SWAA2015040638104Slide · out of positionL2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2015060540390Spar · crackedLEFT WING AFT SPAR UPPER CHORD CRACKED AT RSS 221. REPAIRED SPAR CHORD IAW EA.SDR SWAA2015052239938Skin · crackedSKIN CRACKED AT BS 727D+14, BETWEEN BL 0 TO LBL 1. REPAIRED SKIN IAW EO & EA.SDR SWAA2015051139551Support Fitting · crackedLEFT WING AFT SPAR AFT SUPPORT FITTING CRACKED AT RSS 222.0. R & R FITTING IAW SRM & DWG.SDR SWAA2015051139573Doubler · corrodedAFT CARGO COMPARTMENT FRAME DOUBLER CORRODED AT BS 787, BETWEEN STRINGER 26R - 27R. R & R DOUBLER IAW SRM.SDR SWAA2015050639338Support · crackedAFT CARGO COMPARTMENT SUPPORT ZEE CRACKED AT BS 727E, STRINGER 25R. REPAIRED SUPPORT ZEE IAW SRM.SDR SWAA2015042738982Tie Down · crackedAFT CARGO COMPARTMENT CARGO TRACK TIE DOWN CRACKED AT BS 747, RBL 13.80. REPAIRED TIE DOWN IAW SRM & DWG.SDR SWAA2015042438884Flap · delaminatedLEFT WING OTBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015042438883Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 847 - 867, STRINGER 19R. R & R INTERCOSTAL IAW DWG.SDR SWAA2015042038669Skin · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED AT OTBD EDGE UPPER SKIN. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015042038668Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED AT OTBD EDGE. REPAIRED AFT FLAP IAW SRM.SDR SWAA2015041338395Skin · delaminatedLEFT WING NR 2 SLAT OTBD EDGE UPPER SURFACE DELAMINATED. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2015040638142Lens · missingFORWARD ENTRY EMER EXIT LENS COVER AT FWD WALL MISSING. INSTALLED LENS IAW AMM.SDR SWAA2015040638105Structure · crackedRIGHT HORIZONTAL STABILIZER CRACKED FWD OF LOWER AFT SPAR, APPROX STABILIZER STATION 97. REPAIRED STABILIZER IAW SRM.SDR SWAA2015040638103Battery · dischargedFORWARD OTBD EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2015040638100Control Unit · faultyDIVERSION, SYS A ENG DRIVEN HYDRAULIC PUMP LOW PRESS LIGHT ILLUMINATED SYS A HYD QTY STABILIZED AT 1/4 FOR A LONG PERIOD THEN SLOWLY DECREASED TO NEAR ZERO. R & R A AILERON & ELEVATOR POWER CONTROL UNIT IAW MM.SDR SWAA2015052940204Frame · crackedFUSELAGE FRAME CRACKED AT STATION 947.5, STRINGER 19R. REPAIRED FRAME IAW EA.SDR SWAA2015052940203Frame · crackedFUSELAGE FRAME CRACKED AT STATION 1006, STRINGER 21L. REPAIRED FRAME IAW EA.SDR SWAA2015052640011Frame · crackedFRAME CRACKED AT BS 947.5, STRINGER 19R. REPAIRED FRAME IAW EA.
Back to Boeing 737-3H4