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 SWAA2014042827392Web · crackedLEFT NLG WW WEB CRACKED AT BS 251.625+7, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014042827384Web · crackedLEFT SIDE NLG WW WEB CRACKED AT BS 251.625+7, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014042827378Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 807, STRINGER 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042427346Frame · crackedFRAME CRACKED AT BS 500B, STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014042327324Support Angle · crackedSUPPORT ZEE CRACKED BETWEEN BS 727C TO BS 727D, STRINGER 25R. R & R SUPPORT ZEE IAW SRM.SDR SWAA2014041627169Support · crackedSIDEWALL PANEL SUPPORT STRUCTURE CRACKED AT BS 747, STRINGER 19L. REPAIRED STRUCTURE IAW SRM.SDR SWAA2014041427106Crease Beam · corrodedFORWARD ENTRY DOOR UNDER CREASE BEAM WEB CORRODED. R & R WEB IAW SRM & DWG.SDR SWAA2014041427075Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 19L. R & R TIE CLIP IAW SRM.SDR SWAA2014041427074Tie Clip · crackedTIE CLIP CRACKED AT BS 727C, STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014042827381Skin · crackedSKIN CRACKED AT BS 328.1, STRINGER 17R. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014042227270Fitting · crackedCLIP CRACKED AT BS 947, BETWEEN STRINGER 24L TO STRINGER 25L. R & R CLIP IAW SRM & DWG.SDR SWAA2014042227269Fitting · crackedCLIP CRACKED AT BS 947, BETWEEN STRINGER 24R TO STRINGER 25R. R & R CLIP IAW SRM & DWG.SDR SWAA2014040226762Light · damagedL2 DOOR EMERGENCY EXIT LIGHT DAMAGED. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014043027533Structure · crackedT CHORD CRACKED AFT END OF THE CROSSBEAM OF AFT CARGO DOOR. REPAIRED T CHORD IAW EA.SDR SWAA2014042827380Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 663.75+1.5, RBL 24.5+14. REPAIRED WEB IAW EO & EA.SDR SWAA2014041727197Girt Bar · out of positionL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF POSITION. REPOSITIONED GIRT BAR IAW MT.SDR SWAA2014043027532Structure · crackedCHORD CRACKED AT BS 727, 18A LT AT FWD LOWER FASTENER HOLE OF INSPECTION AREA 12 & 6 O'CLOCK. REPAIRED CHORD IAW EA.SDR SWAA2014043027531Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT AT FWD LOWER FASTENER HOLE OF INSPECTION AREA 3 & 9 O'CLOCK DIRECTION. REPAIRED CHORD IAW EA.SDR SWAA2014041627168Web · crackedWEB CRACKED AT BS 227.8, BL 0. R & R WEB IAW SRM & DWG.SDR SWAA2014041427104Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709, LBL 25. REPAIRED WEB IAW EA.SDR SWAA2014041026982Support Angle · crackedLEFT MAIN WW SUPPORT ANGLE CRACKED AT BS 727, LBL 16. R & R ANGLE IAW SRM & DWG.SDR SWAA2014040726850Plate · crackedPLATE CRACKED AT BS 697, STRINGER 21L. R & R PLATE IAW SRM.SDR SWAA2014040726849Plate · crackedPLATE CRACKED AT BS 697, STRINGER 21R. R & R PLATE IAW SRM.SDR SWAA2014040226761Stiffener · corrodedCHANNEL STIFFENER CORRODED AT BS 1016, RBL 1. REPAIRED STIFFENER IAW EA.SDR SWAA2014040126700Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OFF, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2014033126660Light · missingR1 DOOR LOWER EMERGENCY EXIT LIGHT COVER MISSING. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014041427105Crease Beam · crackedFORWARD ENTRY DOOR CREASE BEAM CRACKED AT BS 351 AT FLOOR LEVEL. R & R BEAM IAW DWG & SRM.SDR SWAA2014040726881Fastener · missingFRAME INNER CHORD FASTENER MISSING AT BS 348.2, STR 15L. INSTALLED FASTENER IAW EA & DWG.SDR SWAA2014042127230Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2014041627174Panel · crackedLEFT WING LOWER TE PANEL JUST OTBD NR 1 ENG PYLON CRACKED. R & R PYLON IAW MM.SDR SWAA2014041427116Skin · crackedSKIN CRACKED AT BS 500C + 16, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014041427115Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014041427097Skin · crackedSKIN CRACKED AT BS 500D, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014040826922Stiffener · corrodedSTIFFENER CORRODED AT BS 227.8, BL 0. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014040826930Mount Bracket · crackedFORWARD FACE OF 178 BULKHEAD GLIDE SLOPE ANTENNA MOUNT BRACKET CRACKED AT LOWER LT CORNER. REPAIRED MOUNT IAW EA & EA.SDR SWAA2014040826927Fitting · crackedRIGHT WING LOWER TE PANEL CLIP JUST OTBD NR 2 ENG PYLON CRACKED. R & R CLIP IAW SOPM.SDR SWAA2014040726848Channel · corrodedSTIFFENER CHANNEL CORRODED AT BS 227.8, LBL 4. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014040726847Channel · corrodedSTIFFENER CHANNEL CORRODED AT BS 227.8, RBL 4. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014040326804Angle · crackedLEFT WING TE, RSS 545 AT INBD AILERON AREA, AFT SIDE OTBD CORNER ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014033126656Battery Pack · inoperativeRT EMERGENCY EXIT LIGHT BATTERY PACK INOPERATIVE AT BS 986.5. R & R BATTERY PACK IAW AMM.SDR SWAA2014032726569Angle · crackedLEFT WING FORE FLAP TE SHELF PANEL ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014032726553Light · inoperativeFORWARD ENTRY DOOR EXTERNAL EMERGENCY EXIT LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2014041727205Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 LOWER INBD CORNER AT FLOOR. R & R CHORD IAW ER & EA.SDR SWAA2014040726846Skin · crackedAFT ENTRY DOOR SKIN CRACKED ON INNER SKIN LOCATED AT BEAM NR 6. R & R SKIN IAW SRM & DWG.SDR SWAA2014040326802Skin · crackedSKIN CRACKED AT BS 500D, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014040226760Stiffener · corrodedSTIFFENER CORRODED AT BS 1016+1, LBL 1. REPAIRED STIFFENER IAW EA.SDR SWAA2014040126714Stringer · corrodedSTRINGER 26R CORRODED BETWEEN BS 1006 - 1016. R & R STRINGER IAW SRM.SDR SWAA2014032726557Battery · dischargedFORWARD OTBD FLASHLIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2014032626516Mount Bracket · brokenR2 DOOR EMERGENCY EVAC SLIDE AFT SIDE MOUNT BRACKET BROKEN. R & R BRACKET IAW SRM.SDR SWAA2014032626522Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. R & R COVER ASSEMBLY IAW SIP.
Back to Boeing 737-3H4