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 SWAA2015033138010Angle · crackedAFT CARGO BAY SIDE WALL SUPPORT J ANGLE CRACKED AT BS 787, BETWEEN STRINGER 23L. R & R J ANGLE IAW SRM & DWG.SDR SWAA2015030337049Strap · crackedFLOOR STABILIZER STRAP CRACKED AT BS 320, LBL 10. R & R STRAP IAW SRM & DWG.SDR SWAA2015030237000Cover · missingLEFT OVERWING EMER EXIT SIGN COVER MISSING. INSTALLED COVER IAW SIP.SDR SWAA2015022636931Retaining Clip · looseL1 DOOR EMER EVAC SLIDE GIRT BAR RETAINING CLIPS LOOSE. SECURED CLIP IAW AMM.SDR SWAA2015022636920Cover · detachedL1 DOOR EMER EXIT LIGHT COVER LOOSE DETACHED. ATTACHED COVER IAW AMM.SDR SWAA2015042438915Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18L. R & R CHORD IAW ER & EA.SDR SWAA2015042038655Frame · crackedFUSELAGE FRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18R. R & R CHORD IAW EA, ER & SRM.SDR SWAA2015031337422Tail Cone · delaminatedTAIL CONE DELAMINATED AT LT SIDE BELOW HORIZONTAL STAB. REPAIRED TAIL CONE IAW SRM.SDR SWAA2015022536884Spindle · corrodedRIGHT WING NR 7 MID FLAP CARRIAGE SPINDLE HVOF COATING CORRODED IN LOWER ROOT AREA. R & R SPINDLE IAW MT.SDR SWAA2015022536874Flap Track · crackedRIGHT WING NR 7 FLAP TRACK AN ARM FOR FAIRING CRACKED IN ARM. R & R NR 7 AFT FLAP TRACK IAW CMM.SDR SWAA2015022436860Slide · looseR1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW SIP & MT.SDR SWAA2015022336798Support Channel · crackedFOUND VHF NR 3 ANTENNA SUPPORT CHANNEL CRACKED. REPAIRED CHANNEL IAW ER & EA.SDR SWAA2015040738198Lens · defectiveLEFT SIDEWALL EMER EXIT SIDEWALL 2320Z LIGHT LENS INOPERATIVE. R & R LENS IAW DWG.SDR SWAA2015030937267Carriage · corrodedLEFT WING FLAP CARRIAGE NR 3 OTBD HALF AFT BOLT HOLE CORRODED. R & R CARRIAGE ARM IAW CMM.SDR SWAA2015030937266Carriage · corrodedLEFT WING FLAP TRACK CARRIAGE NR 3 INBD HALF AFT ROLLER BOLT HOLE CORRODED. R & R CARRIAGE ARM IAW CMM.SDR SWAA2015022736968Web · crackedLONGITUDINAL WEB CRACKED BETWEEN BS 500D TO 520. R & R WEB IAW SRM.SDR SWAA2015022536876Fitting · corrodedRIGHT NOSE GEAR LOWER LOCK ACTUATOR BRACKET CORRODED. REPAIRED FITTING IAW EA.SDR SWAA2015022536875Fitting · corrodedLEFT NOSE GEAR LOWER LOCK ACTUATOR BRACKET CORRODED. REPAIRED FITTING IAW EA.SDR SWAA2015022336828Hook · looseR1 DOOR EMER EVAC SLIDE AFT GIRT BAR HOOK COVER ASSEMBLY LOOSE. R & R HOOK ASSEMBLY IAW SRM.SDR SWAA2015022336811Cover · looseLEFT OVERWING EMER EXIT SIGN COVER LOOSE. R & R COVER IAW AMM.SDR SWAA2015022336800Slide · low pressureL2 DOOR EMER EVAC SLIDE PRESS LOW. R & R SLIDE IAW AMM & MT.SDR SWAA2015041338403Skin · crackedLEFT WING UPPER SKIN AT TE FASTENER HOLES COMMON THE REAR SPAR UPPER CHORD CRACKED BETWEEN STATION 237.5 - 256.5. REPAIRED CHORD IAW EA.SDR SWAA2015033138005Skin · crackedRIGHT WING UPPER SKIN AT TE CRACKED AT THE FOLLOWING BETWEEN REAR SPAR STATION 239 - 269. REPAIRED SKIN IAW EA.SDR SWAA2015032337718Carriage · corrodedRIGHT WING OTBD MID FLAP NR 7 CARRIAGE, BOTH LOWER A FRAME MOUNT HOLES CORRODED. R & R NR 7 CARRIAGE IAW CMM.SDR SWAA2015031637458Spindle · crackedLEFT WING OTBD MID FLAP NR 2 CARRIAGE SPINDLE CRACKED. R & R NR 2 SPINDLE IAW MM.SDR SWAA2015022336812Lens · crackedL1 DOOR SLIDE EMER EVAC SLIDE COVER LENS CRACKED. R & R LENS IAW AMM & MT.SDR SWAA2015022336799Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 727D - 727E, BETWEEN STRINGER 27L - 27R. REPAIRED SKIN IAW EA.SDR SWAA2015040938294Fitting · corrodedRIGHT WING REAR SPAR AFT INBD BATHTUB FITTING CORRODED. REPAIRED FITTING IAW SRM.SDR SWAA2015030937212Support · crackedAFT CARGO FWD BULKHEAD PANEL SUPPORT CRACKED AT BL 0, WL166. R & R SUPPORT IAW SRM & DWG.SDR SWAA2015021936729Door Frame · crackedR1 DOOR EDGE FRAME LOWER AFT CORNER AT STOP FITTING CRACKED. R & R DOOR IAW MM.SDR SWAA2015021936728Strap · crackedFLOORBEAM STRAP CRACKED AT BS 328, LBL 12. REPAIRED STRAP IAW SRM.SDR SWAA2015021936727Power Supply · inoperativeLEFT BULLNOSE EMER LIGHTS INOPERATIVE BETWEEN ROW 1 & 2. R & R POWER SUPPLY IAW AMM.SDR SWAA2015022036756Lens · looseRIGHT OVERWING EXIT EMER SIGN LENS ABOVE DOOR LOOSE. SECURED LENS IAW AMM.SDR SWAA2015021836709Mount Bracket · crackedR2 DOOR EMER EVAC SLIDE AFT MOUNT BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2015021836708Slide · out of adjustR2 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW AMM.SDR SWAA2015021836707Lens · looseRIGHT EMER EXIT LIGHT LENS LOOSE AT ROW 24. SECURED LENS IAW MM.SDR SWAA2015021836702Lens · looseL1 DOOR EMER EVAC SLIDE LENS LOOSE. SECURED LENS IAW MM & MT.SDR SWAA2015021836701Lens · looseR1 DOOR EMER EVAC SLIDE LENS LOOSE. SECURED LENS IAW MM & MT.SDR SWAA2015032337703Keelbeam · corrodedAFT RT KEEL BEAM CORRODED AT BS 720, RBL 7. REPAIRED KEEL BEAM IAW SRM.SDR SWAA2015032337704Keelbeam · corrodedAFT LT KEEL BEAM CORRODED AT BS 720, LBL 7. REPAIRED KEEL BEAM IAW SRM.SDR SWAA2015021836687Fuse · inoperativeAIR TURN BACK, LE DEVICES WILL NOT RETRACT NR 3 & 5, INDICATE IN TRANSIT. R & R LE EXTEND FUSE IAW AMM.SDR SWAA2015031737528Stiffener · crackedAFT CARGO LT VERTICAL STIFFENER CRACKED AT BS 727, LBL 6.3. R & R STIFFENER IAW DWG & SRM.SDR SWAA2015031737529Stiffener · crackedAFT CARGO RT VERTICAL STIFFENER CRACKED AT BS 727, RBL 6.3. R & R STIFFENER IAW DWG & SRM.SDR SWAA2015021736644Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 420, STRINGER 1L. R & R CLIP IAW SRM & DWG.SDR SWAA2015031237377Bulkhead · corrodedFORWARD SIDE OF PRESS DOME CORRODED AT BS 1016, LBL 1. REPAIRED DOME IAW EA.SDR SWAA2015030537148Skin · corrodedSKIN CORRODED BETWEEN BS 927 TO 947, LBL 2. REPAIRED SKIN IAW SRM.SDR SWAA2015021936718Shear Tie · crackedSHEAR TIE CRACKED AT BS 360, BETWEEN STRINGER 14R TO 15R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015021636633Lens · brokenL1 DOOR EMER EXIT SIGN LENS BROKEN. R & R LENS IAW MM.SDR SWAA2015021636627Skin · crackedFUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUT OUT LOWER FWD RADIUS. REPAIRED SKIN IAW SRM.SDR SWAA2015032637853Fitting · crackedL1 DOOR LOWER HINGE LOWER FITTING CRACKED AT FUSELAGE CUT OUT. R & R FITTING IAW EA.
Back to Boeing 737-3H4