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 SWAA2014072530344Fuse · blownRIGHT FWD EMER EXIT LIGHT INOPERATIVE AT BS 360. R & R F2 FUSE IAW AMM.SDR SWAA2014072530332Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014072530331Slide · deployedL2 DOOR EMER EVAC SLIDE DEPLOYED DURING EMER. R & R SLIDE IAW MT.SDR SWAA2014072530330Slide · deployedL1 DOOR EMER EVAC SLIDE DEPLOYED FOR EVACUATION. R & R SLIDE IAW MT.SDR SWAA2014072430293Sensor · faultyAIR TURN BACK NR 1 LE FLAP TRANSIT LIGHT ILLUMINATED DURING CLIMB OUT ABOVE 10,000'. R & R NR 1 LE FLAP UP STOW STRINGER 168 SENSOR IAW MM.SDR SWAA2014072330213Sensing Element · faultyAIR TURN BACK RT WING TO BODY OVERHEAT LIGHT ILLUMINATED. R & R SENSOR ELEMENT M371 IAW MM.SDR SWAA2014082731314Crossbeam · crackedAFT CARGO DOOR FWD END OF CROSSBEAM OUTER CHORD CRACKED. REPAIRED DOOR IAW EA.SDR SWAA2014082731313Frame · crackedLEFT FRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727 STRINGER 18A. REPAIRED CHORD IAW SWA.SDR SWAA2014082731312Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED BETWEEN BS 663.75 TO 675 BETWEEN RBL 37 TO 44. REPAIRED WEB IAW SRM.SDR SWAA2014081930988Door Frame · crackedAFT ENTRY DOOR STUB FRAME CRACKED AT BS 950 STRINGER 17L. REPAIRED FRAME IAW EA.SDR SWAA2014080430588Channel · corrodedZ CHANNEL CORRODED AT BS 500C+12 LBL 24. REPAIRED Z CHANNEL IAW SRM.SDR SWAA2014072530335Light · inoperativeRIGHT OVERWING EMER EXIT LIGHT BULB INOPERATIVE. RE-LAMPED BULB IAW AMM.SDR SWAA2014072530334Light · inoperativeRIGHT OVERWING EMER LIGHT BULB INOPERATIVE. RE-LAMPED BULB IAW AMM.SDR SWAA2014072530333Light · inoperativeRIGHT OVERWING EMER EXIT LIGHT BULB INOPERATIVE. RE-LAMPED BULB IAW MM.SDR SWAA2014072330212Lens · looseL1 DOOR EMER EXIT LIGHT COVER LOOSE. INSTALLED LENS IAW SIP.SDR SWAA2014072330252Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2014081130742Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 344 STRINGER 23L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081130731Fitting · looseLEFT NLG DOOR CONTROL ROD TRUNNION FITTING LOOSE. SECURED FITTING IAW CMM.SDR SWAA2014080830707Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5 STRINGER 27R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014080730676Skin Panel · damagedRIGHT WING OTBD FORE FLAP EXTERNAL UPPER SKIN PANEL DAMAGED AT WBL 213. REPAIRED SKIN IAW EO & EA.SDR SWAA2014080430554Web · crackedWEB CRACKED AT BS 967 LBL 19. R & R WEB IAW SRM & DWG.SDR SWAA2014080130527Web · corrodedWEB CORRODED BETWEEN BS 887 TO 907 STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2014072930447Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 23L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014072230209Fan · faultyELECTRICAL SMELL COMING FROM FWD & AFT GALLEY & SPREAD THRU CABIN. R & R RECIRC FAN IAW MM.SDR SWAA2014081130741Tee Fitting · crackedFORMER TEE CHORD CRACKED AT BS 540 BETWEEN STRINGER 22L TO 28L. R & R CHORD IAW SRM & DWG.SDR SWAA2014080830706Fitting · crackedCLIP CRACKED AT BS 540 RBL 2. R & R CLIP IAW SRM & DWG.SDR SWAA2014080830705Fitting · crackedCLIP CRACKED AT BS 540 LBL 2. R & R CLIP IAW SRM & DWG.SDR SWAA2014080830704Bracket · crackedAFT CARGO COMPARTMENT WEB BRACKET CRACKED AT BS 727A STRINGER 25R. R & R BRACKET IAW SRM & DWG.SDR SWAA2014080630641Frame · crackedFRAME CRACKED AT BS 947.5 STRINGER 19L. R & R FRAME IAW SRM & DWG.SDR SWAA2014080130526Frame · crackedFRAME CRACKED AT BS 947.5 STRINGER 19R. R & R FRAME IAW SRM & DWG.SDR SWAA2014073130498Angle · crackedANGLE CRACKED BETWEEN BS 927 TO 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014072930441Stiffener · crackedRIGHT WING NR 6 FLAP TRACK FAIRING TE UPPER STIFFENER CRACKED AT WBL 188.40. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014072830400Channel · crackedSTRINGER CHANNEL CRACKED AT BS 727 STRINGER 23R. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014072830409Stiffener · crackedLEFT WING NR 3 TE UPPER STIFFENER CRACKED ON WBL 188.40 INBD SIDE. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014072830406Stiffener · crackedLEFT WING NR 3 FLAP TRACK FAIRING TE INTERNAL STRUCTURE INBD SIDE LOWER STIFFENER CRACKED AT WBL 188.40. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014072330247Tie Clip · crackedTIE CLIP CRACKED AT BS 727A STRINGER 26R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014080430589Skin · crackedSKIN CRACKED AT BS 847 STRINGER 14L. REPAIRED SKIN IAW EA.SDR SWAA2014080130530Fairing · delaminatedLEFT WING INBOUND FLAP TRACK CANOE FAIRING DELAMINATED. REPAIRED FAIRING IAW EA.SDR SWAA2014080130525Tie Clip · crackedTIE CLIP CRACKED AT BS 500A STRINGER 21R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014072330226Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 887 STRINGER 13L. R & R CLIP IAW DWG & SRM.SDR SWAA2014072330225Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 747 STRINGER 13L. R & R CLIP IAW DWG.SDR SWAA2014072130135Sign · unsecureAFT GALLEY EMER EXIT SIGN FELL OUT. R & R SIGN IAW AMM.SDR SWAA2014072130103Pump · leakingDECLARED EMER HYD SYS A QTY & PRESS REDUCED TO ZERO INFLIGHT. R & R NR 1 ENG HYD PUMP IAW MM.SDR SWAA2014081930968Skin · crackedAFT ENTRY DOOR SKIN CRACKED AT BS 950 STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014081530914Rib · crackedLEFT WING RIB WEB CRACKED AT WBL 198.6 STRINGER 5. REPAIRED WEB IAW EO & EA.SDR SWAA2014081330827Rib · crackedRIGHT WING UPPER WEB RIB CRACKED AT WBL 198.60 STRINGER 5. REPAIRED RIB WEB IAW EO & EA.SDR SWAA2014081130740Plate · crackedFORWARD CARGO COMPARTMENT PLATE CRACKED AT BS 492 BETWEEN STRINGER 25R TO 26R. R & R PLATE IAW SRM & DWG.SDR SWAA2014080730675Beam · brokenHINGE BEAM BROKEN BETWEEN BS 1088 TO 1094 LOWER STRINGER 20R. R & R BEAM IAW SRM & DWG.SDR SWAA2014080630629Floorbeam · crackedFLOORBEAM WEB CRACKED AT BS 616 LBL 45.5. REPAIRED WEB IAW EA.SDR SWAA2014080630640Plate · crackedVERTICAL STABILIZER ACCESS PANEL 9506 PLATE CRACKED. R & R PLATE IAW SRM & DWG.
Back to Boeing 737-3H4